The enclosed file contains data which is added to on a daily basis. It shows work done by individuals on shifts. I would like to be able to show a League Table of the people which automatically updates based on the various columns. I have manually produced the stats for one individual on the sheet, but would like this to be produce for all the individuals automatically and shown in descending order based on AVGE % DONE. I have added some comments to help explain where the data comes from. Any help is appreciated. Kevin
A Simple pivot table will do this, see attached
Last edited by Kyle123; 01-31-2012 at 04:41 AM.
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
Thanks for your help. However, the numbers in the Pivot Table for Disputed and Missed is wrong for each individual. As an example M.Wyles shoud be 6 Disputed and 8 Missed. A.Appleton should be 0 Disputed and 11 Missed.
My Mistake change disputed and missed to sum rather than count.
I don't understand where you get 8 Missed from for M.Wyles, he has missed 10?
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks