Counting Unique value in excel
How to count unique value in excel just like sql
select Count(distinct col) from tnb
select Count(distinct col) from tnb
1 answers ( 0 marked as helpful)
Hi Vaibhav!
Thanks for reaching out!
The most straightforward approach to finding the unique values in an Excel array would be to use COUNT(UNIQUE(array)) . For example, for the array C2:C12, the formula would be:=COUNT(UNIQUE(C2:C12))
Hope this helps.
Kind regards,
Martin
