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 a 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!

You don't specify what an offence is. I'd have thought that it is OT hours
in col F. Is it?
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"T. Jaques" wrote:

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 a 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!

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.
--
HTH...

Jim Thomlinson


"T. Jaques" wrote:

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 a 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!