View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SouthCarolina
 
Posts: n/a
Default Counting non-repeating dates

I am trying to count dates in a column that do not repeat. For example

3/12/2006
3/14/2006
4/1/2006
4/1/2006
4/12/2006
0
0

I want the count function to return "4" as the number of entries.
Basically, I want it to exclude zeros and repeating dates. Do you have any
suggestions?