Thread: Find X number of smallest values in a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Haack Steve Haack is offline
external usenet poster
  
Posts: 44
Default Find X number of smallest values in a range
I have a range of cells (say 10 cells) with various numbers in them. I need
to find the average of the 5 smallest numbers in the range.

How do I do that?

Thanks,
Steve
Reply With QuoteReply With Quote