| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count unique dates within each unique ID
I have 2 columns one with a person ID and the other with various
dates. The file is sorted by person ID. I need to count each unique date within each ID. So for example if ID 1234 has 3 dates in column b 8/14, 8/15 and 8/15 again, it would only count 2 and not 3 at the last occurrence in cell A which is the ID. 100310 5/6/09 136438 5/15/09 136438 5/16/09 136438 5/16/09 279700 5/21/09 296296 5/1/09 316073 5/26/09 329053 5/12/09 Thanks for any help you can provide. CD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count the number of unique dates | Excel Worksheet Functions | |||
| Pivot Table Sub Total Count Unique Dates | Excel Worksheet Functions | |||
| Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
| How can I count the number of unique dates in a Pivot Table? | Excel Discussion (Misc queries) | |||
| Charting count of unique dates in a list | Charts and Charting in Excel | |||
Threaded Mode
