Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding multiple items from a list | Excel Worksheet Functions | |||
Finding last items in a list | Excel Programming | |||
copying list items | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Items in disabled items list - unknown excel addins causing probs | Excel Programming |