Return top ten amounts

[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

 

[Glenn]

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.

 

[Spiky]

To get them in another

area of the worksheet, use the LARGE() worksheet function.

Or a filter.