Top 25 offenders after summing

T

T. Jaques

Help! I have a large spreadsheet that is updated weekly with overtime
offenders.
It is set up as follows:
Column A: Pay Period Ending
Column B: Supervisor
Column C: Cost Center
Column D: Last Name
Column E: First Name
Column F: OT Hrs
Column G: Explanation
Currently I have a filter active on the sheet so that they can just look at
one week or one person, etc. What I need to be able to do, is show the top
25 offenders each quarter. Quarter end dates are: 10/03/09, 01/02/09,
04/03/10 and 07/03/10. He wants to be able to see this at a glance each
quarter. I'm ok with having another sheet created if I need to. Help!
 
J

Jim Thomlinson

That can be done with a pivot table. Since your quarters do not land on month
ends you will want to create a seperate column to identify which quarter each
record belongs to. That can be either hard coded or you could use a lookup
type formula.

Here is a link to creating pivot tables...
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Once you have your pivot table you will want to change the field settings of
the supervisor (I assume that is the offender) Field Settings | Advanced
Change the sort and the Top 10 to top 25.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top