Thread
:
Count the number of unique records
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Aladin Akyurek
Posts: n/a
Count the number of unique records
=SUMPRODUCT(--($B$2:$B$17=D2),($A$2:$A$17<"")/COUNTIF($A$2:$A$17,$A$2:$A$17&""))
where D2 houses the date of interest.
wrote:
I have this table of data:
refid Date
95528 10/22/2004
95528 10/22/2004
95312 10/22/2004
95312 10/22/2004
95261 10/22/2004
95261 10/22/2004
95051 10/23/2004
95051 10/23/2004
95051 10/23/2004
94999 10/23/2004
94999 10/23/2004
94806 10/24/2004
94806 10/24/2004
94737 10/24/2004
94737 10/24/2004
94678 10/24/2004
I need to do a count only counts a REFID once and only between certian
dates. So, sort of count the number of REFID's that fall on 10/23/2004.
Make sence?
Also, it needs to be done in one formula. Obviously this requires an
array formula. I have a formula that counts the number of entires
between certian dates, but I can't figure out how to count a REFID only
once.
Cheers!
Reply With Quote