Return top ten amounts
 

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

Return top ten amounts
 

Jane Doe wrote:
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


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.

Return top ten amounts
 

To get them in another
area of the worksheet, use the LARGE() worksheet function.

Or a filter.