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

count unique entries
 

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
---------------
Jacob Skaria


"driller2" wrote:

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

count unique entries
 

Try this...

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

--
Biff
Microsoft Excel MVP


"driller2" wrote in message
...
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

count unique entries
 

thank you !

count unique entries
 

You're welcome!

--
Biff
Microsoft Excel MVP


"driller2" wrote in message
...
thank you !

count unique entries
 

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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"driller2" wrote:

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