Thread: HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HelpExcel.com[_2_] HelpExcel.com[_2_] is offline
external usenet poster
  
Posts: 39
Default HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
You can use a formulaic array similar to the following:

=AVERAGE(IF(RANK(A1:A10,A1:A10)4,A1:A10,""))

Make certain you replace A1:A10 with the range of numbers you want to
average and press cntrl-shift-enter
--
Regards,
Eddie
http://www.HelpExcel.com


"FUNACH" wrote:

NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6?
Reply With QuoteReply With Quote