View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
uncmello uncmello is offline
external usenet poster
 
Posts: 2
Default Count of unique values in a list

I need the total number of unique values in a list. I don't what to know how
many of each value there is.
Here's an example
33071
33071
33071
33072
33683
33912
33912
33912
33953
34250
In this case I need the answer to be 6
I also would like it to update the answer when I change the filter. Is that
possible?