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!

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

--


Gary


"mclifford973" wrote in message
...
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!

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



On Aug 25, 10:29*am, "Gary Keramidas" <GKeramidasATmsn.com wrote:
try autofilter and see if it will do what you want.

--

Gary

"mclifford973" wrote in message

...



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!- Hide quoted text -

- Show quoted text -