Counting

  • Thread starter Thread starter Karl
  • Start date Start date
K

Karl

Is it possible to count the number of unique dates in a spicifi
column? Ex. A column could contain 6- 4/18/04 dates, 2- 4/30/04 date
and 4- 5/10/04 dates the answer would be
 
One way

=SUM(IF(A1:A100<>"",1/COUNTIF(A1:A100,A1:A100)))

entered with ctrl + shift & enter

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top