Return top ten amounts

  • Thread starter Thread starter Jane Doe
  • Start date Start date
J

Jane Doe

What is the simplest way to return the ten highest amounts listed in a column?

I have a column that list total cost, and I would like to list the ten
highest amounts from that column. Would I use formula or filter? Please
explain detail. Thank you
 
Jane said:
What is the simplest way to return the ten highest amounts listed in a column?

I have a column that list total cost, and I would like to list the ten
highest amounts from that column. Would I use formula or filter? Please
explain detail. Thank you
Click to expand...


To get the ten highest amounts "in place", use a filter. To get them in another
area of the worksheet, use the LARGE() worksheet function.

The help file can provide details.
 
Back
Top