Count the number of unique records
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!
|