Counting the number of different values in a column

[stanelburger]

Hi,

How can I count the number of different dates in a column? For example if I had:

03-Jul-12

03-Jul-12

03-Jul-12

04-Jul-12

04-Jul-12

04-Jul-12

05-Jul-12

<tbody>
</tbody>

The formula would return "3".

Thanks!

 

[Rick Rothstein]

If your dates are always in sort order, as shown, then I think this formula will work for you...

=SUMPRODUCT(1*(A1:A7<>A2:A8))

 

[Smitty]

Welcome to the Board!

See: http://office.microsoft.com/en-us/e...nique-values-in-a-data-range-HP003056118.aspx

HTH,

 

[stanelburger]

Yes, they are in sort order. Both of these are extremely helpful. Thank you very much!

 

[T. Valko]

Hi,

How can I count the number of different dates in a column? For example if I had:

03-Jul-12

03-Jul-12

03-Jul-12

04-Jul-12

04-Jul-12

04-Jul-12

05-Jul-12

<TBODY>
</TBODY>

The formula would return "3".

Thanks!

Try this...

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