LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Top 25 offenders after summing

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing Lisa S. Excel Worksheet Functions 11 August 29th 07 05:56 PM
summing Hasty Excel Worksheet Functions 2 June 24th 07 04:31 PM
PivotTable and summing/not summing ~*Amanda*~[_2_] Excel Discussion (Misc queries) 1 March 14th 07 07:35 PM
Summing all BUT one... popunonkok Excel Worksheet Functions 6 April 26th 06 08:35 PM
Help with summing Carl Brehm Excel Worksheet Functions 3 January 3rd 05 01:17 PM


All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"