View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] rodeoratt@discussions.microsoft.com is offline
external usenet poster
 
Posts: 7
Default Need help with range of cells

I am needing help; I use spreadsheets entering 6 scores and have to throw out
the high and low and average the remaining 4. This I can do; BUT if we add 6
more scores to the scenario making a total of 12, is there a way to throw out
3 high and 3 low and average the remaining 6?

Thank you for any suggestions!!