LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Finding/Copying Top 10 Items From A List

Here is an example of my data. I am trying to take the top 3 late
cases and copy them to a spreadsheet. If the person has 0 cases, then
return no data. If the person has more than 3, only return data that
is the top 3 items based on Days Late.

Name Days Late Case Number
Bob 76 1234
Bob 82 2134
Bob 90 3324
Bob 4 5542
Rick 14 2239

1: I want only Bob's top 3 days by highest number of Days Late.
2: If I am looking for Sam, Sam is not on the report, how do I return
no data.

I have tried =Large, Vlookup, If, etc and I'm just not having any
luck. I've also tried a filter with a copy/but the cell references
will change each time the report is re-ran.

Thank you!
 
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
Finding multiple items from a list Col Excel Worksheet Functions 4 September 26th 08 01:39 AM
Finding last items in a list [email protected] Excel Programming 2 October 11th 07 08:58 AM
copying list items Hru48 Excel Discussion (Misc queries) 0 September 28th 05 04:14 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Items in disabled items list - unknown excel addins causing probs Rich Excel Programming 4 May 16th 05 10:31 PM


All times are GMT +1. The time now is 07:50 PM.

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"