MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Counting without duplicates

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


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



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

If your data is in A1:D1 use


Array entered.

Juan Pablo G.