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.
|