View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
driller2[_2_] driller2[_2_] is offline
external usenet poster
 
Posts: 7
Default count unique entries

helllo again,

i a have a "Y" column of date entry.

Most of dates are repeated, some are entered once.

I need to count only the number of dates (excldg repetitions).

example
15-Sep-09
22-Sep-09
20-Oct-09
20-Oct-09
20-Oct-09
22-Oct-09

From above 6 dates; the unique count should be 4.

thanks