Thread: Find Unique
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Find Unique

OK, I have a table like so:

Name Score
------ -------
Bob 80
Jane 90
Jeff 80
Jack 90
Bob 70
Bob 60

I would like to create a formula that will tell me how many unique names are
in column A, so the result in the above case would be 4. How do I do that?