Thread: average of kth largest numbers in an array of n numbers
View Single Post
  #6   Report Post  
Harlan Grove
 
Posts: n/a
Default
"Biff" wrote...
....
Another method:

=SUMIF(A1:A100,"="&LARGE(A1:A100,4))/4
....

That fails when the 4th largest value appears multiple times.


Reply With QuoteReply With Quote