Thread: average low 10 of last 20 entries
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
  
Posts: 570
Default average low 10 of last 20 entries
I have a continuing list of numeric entries. At any one time I want to be
able to cvalculate the average of the lowest 10 of the most recent 20
entries. I'm using Excel 2002.
Reply With QuoteReply With Quote