Count of Unique Items?

  • Thread starter Thread starter Monte Sliger
  • Start date Start date
M

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
 
Try the following...

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

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

Hope this helps!
 
Back
Top