View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bevinb bevinb is offline
external usenet poster
 
Posts: 2
Default Find lowest total of cells in range without sorting

Hi, I have a long list of numbers in a column. I want to find the 5
together that have the lowest sum but do not want to sort them. i.e.,
the lowest total of the five as they are arranged on the spreadsheet
now. I thought I had done this previously and it wasn't that
difficult but now I cannot for the life of me remember how or even if
I did accomplish it! Any help appreciated.

Excel 2003

Thanks, Bevin B.