View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nelson Nelson is offline
external usenet poster
 
Posts: 69
Default How can I count numbers without including the repeated values?

Hi!

How can I count numbers without including the repeated values?
Just take a look at the situation:

John
Mary
John
Rose

The count is equal to 4 but I whant it to be 3 because "John" is repeated.
Thanks a lot!