MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Counting without duplicates


Posted by Lewis on January 30, 2002 4:54 PM

Hey

Whats the best way to count a group of cells not accepting duplictes?? Say the data was NY, NY, NY CA

the sum would be 2

thanks

-Lewis


Posted by Juan Pablo G. on January 30, 2002 6:35 PM

If your data is in A1:D1 use

=SUM(IF(LEN(A1:D1),1/COUNTIF(A1:D1,A1:D1)))

Array entered.

Juan Pablo G.