Thread: Average of low five numbers?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dcnatlou dcnatlou is offline
external usenet poster
  
Posts: 1
Default Average of low five numbers?
Example:

1 2 3 4 5 6 7 8 9 10

3 5 6 7 8 2 1 4 9 0

I want to take low five numbers and average them.
So, 0,1,2,3,4,5 avg. 3
Reply With QuoteReply With Quote