| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique records based on date range | Excel Worksheet Functions | |||
| How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
| Top 90% of records - Bring out number | Excel Discussion (Misc queries) | |||
| Count number of unique items in a column that contains duplicates | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
Threaded Mode
