Excel - Summarising Roles for a Roster [Closed]

 guest -

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.


2 replies

Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
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!