View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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!