Thread: Find the lowest4 numbers of the last 6 in a range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Find the lowest4 numbers of the last 6 in a range
Domenic wrote...
....
=AVERAGE(SMALL(INDEX(A2:P2,LARGE(IF(A2:P2<"",
COLUMN(A2:P2)-COLUMN(A2)+1),6)):P2,{1,2,3,4}))
....

You could shorten that to

=AVERAGE(SMALL(INDEX(2:2,
LARGE(COLUMN(A2:P2)*ISNUMBER(A2:P2),6)):P2,{1;2;3; 4}))
Reply With QuoteReply With Quote