Forum Discussion
Highlight highest 5 values in each of a number of rows
=AVERAGE(LARGE(E2:X2,1),LARGE(E2:X2,2),LARGE(E2:X2,3),LARGE(E2:X2,4),LARGE(E2:X2,5)) I am using the above formula to average the highest 5 numbers in a row of 20 plus numbers that get added to each ...
Hi Vic,
The formula to average could be like
=AVERAGE(AGGREGATE(14,6,$E2:$X2,{1,2,3,4,5}))
The rule formula to highlight largest 5 is
=E2>=AGGREGATE(14,6,$E2:$X2,5)
with the rule applied to your entire range.
And attached.