Count of Unique Items?

[Monte Sliger]

Hi,

I have a worksheet (Sheet1) where column A consists of dates (in date
order). I need to look at this column from another sheet (Sheet2) in the
same workbook and return the number of unique dates in this column. For
example, on Sheet1 cell A1 has the heading Date, A2 is 10/01/04, A3 is
10/01/04, A4 is 10/01/04 and A5 is 10/05/04. From cell A1 on Sheet2 I need
to look at the range A2:A5 on Sheet1 and return the number 2 (the number of
unique dates in the range).

Any help would be greatly appreciated.


Monte Sliger

 

[Domenic]

Try the following...

=SUM(IF(Sheet1!A2:A5<>"",1/COUNTIF(Sheet1!A2:A5,Sheet1!A2:A5)))

....entered using CONTROL+SHIFT+ENTER.

Hope this helps!

 

[Monte Sliger]

Domenic,

That works like a charm! Thanks so much for the help.


Monte Sliger