Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Unique Values In A Filtered Row with Duplicates
Hello,
I've tried to copy and paste below the resource spreadsheet I am working on. What I want to be able to do is list out each project and who the project manager is on that project (now some PMs can work on more than one so there are duplicates). Then I want to be able to subtotal the hours (in case I want to review just one project, one city, or one PM) but also remove the duplicates again. Can you help me out please? THANKS, Joe Jan-2006 Feb-2006 Total Hours: 411.00 411.00 Total Resources Total FTE: Total Unallocated: 0.00 0.00 Resource Name Role Region Project Jan-2006 Feb-2006 Bob PM Toronto 1 106.00 106.00 John PM Winnipeg 2 0.00 0.00 Joe PM Calgary 3 30.00 30.00 Jimmy PM Toronto 4 80.00 80.00 Sam PM Toronto 2 65.00 65.00 Tom Sr. PM Vancouver 6 65.00 65.00 Bob PM Toronto 7 65.00 65.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count and display unique values | Excel Worksheet Functions | |||
count number of values between plus signs in addition calc | Excel Discussion (Misc queries) | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Populate combo box with unique values only | Excel Discussion (Misc queries) | |||
Pivot Table Unique Count | Excel Worksheet Functions |