View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default 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.