Finding/Copying Top 10 Items From A List

M

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!
 
M

mclifford973

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top