Hopefully there are no "ties"

Use VLOOKUP:

say the expenses are in column A with catagory, date, and description in
B,C,D.

=VLOOKUP(LARGE(A:A,1),A1:D100,2,FALSE) for col B
=VLOOKUP(LARGE(A:A,1),A1:D100,3,FALSE) for col C
=VLOOKUP(LARGE(A:A,1),A1:D100,4,FALSE) for col D


then for the next largest:
=VLOOKUP(LARGE(A:A,2),A1:D100,2,FALSE) for col B
etc.
--
Gary''s Student - gsnu200814


"ruffnro" wrote:

I have a list of expenses in one tab of my workbook from an employee's
expense reports. I am trying to find the top 5 expenses for that person to
be summarized on a summary tab. I have used the LARGE function to find the
top 5 dollar amounts, but don't know how to pull the expense category, date
and description into the summary. The detail could be in any order.

Any thoughts or suggestions would be appreciated.

Ron