count unique entries

[driller2]

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

 

[Jacob Skaria]

Try the below

=SUMPRODUCT((Y1:Y100<>"")/COUNTIF(Y1:Y100,Y1:Y100&""))

If cell Y1 is header then adjust the range as Y2:Y100

If this post helps click Yes

 

[T. Valko]

Try this...

=SUM(--(FREQUENCY(A2:A7,A2:A7)>0))

 

[driller2]

thank you !

 

[T. Valko]

You're welcome!

 

[driller2]

thank you.
the formula u shared seems to work also for texts.