View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwgolz edwgolz is offline
external usenet poster
 
Posts: 5
Default Minimun values in a list

I have an array of data in which I'd like to return the sum of the lowest 10
numbers without having to sort. Specifically, I would like to find the lowest
10 cells 1-20, 2-21, 3-22 etc in a list of 100.
Thanks