Excel - Summarising Roles for a Roster [Closed]

Report
-
 guest -
Hello,

I am creating a spreadsheet that will be used to assign rosters and keep track of staffing levels. I have finished most of it but have come up to a final hurdle. I want to be able to create a list of people doing individual roles. Initially I tried a VLOOKUP and this worked ok up until I had several people doing the same role. I also tried to use a pivot table but this only shows total numbers for each role.

Does anyone out there have any suggestions for what I should try? Your help would be much appreciated.

Thanks

2 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Use autofilter
I think you problem could be resolved if you summarize the Data by Sum and not count in your pivote table
right click the pivot and select Summarize Data by Sum . hope this helps

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!