Finding/Copying Top 10 Items From A List

[mclifford973]

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!

 

[Gary Keramidas]

try autofilter and see if it will do what you want.

 

[mclifford973]

Yes I tried filter and it will be rather time consuming to copy/paste
the data to each person's report...