How to Count Unique Values Among Duplicates in Excel Using Function

[@gozdekaramanoglu5914]

The formula he used is *=UNIQUE(A1:B4, FALSE, FALSE)* and *not =UNIQUE(A2:A5, false, false)* as he first shows because this range does not include the row of B which is needed to enter the first "false argument". If anybody is getting errors that's probably why

[@vignesh-office3657]

Getting spill error