| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count unique values among duplicates in a subtotal range
Hello,
I have a list of names of people associated with a list of projects. One person can manage more than one project so the same name can appear many times. I would like to be about to count the number of unique names in this list. Now that catch is that I also have a column for region (ie: east coast, west coast, etc.) so I would like to be able to use the filters but the count should be able to adjust accordingly. Ie: My List Joe Project A EastCoast Joe Project B EastCoast Bob Project A WestCoast Steve Project C Central I would love to get a count above of 3 names, but then also be able to filter for "Project A" and get 2 names for the count. i know this one is pushing the limits of excel but I was hoping someone could help me out. THANKS! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique values - Pivot Table | Excel Discussion (Misc queries) | |||
| Count unique values - Pivot Table | Charts and Charting in Excel | |||
| Summing values within a range | Excel Discussion (Misc queries) | |||
| count unique with conditions | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Threaded Mode
