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!