Average formula
Muhammed Rafeek M wrote:
Hi
Hope below mentioned function will solve your problem.
=AVERAGE(LARGE(A1:A15,1),LARGE(A1:A15,2),LARGE(A1: A15,3),LARGE(A1:A15,4))
With Regards
Rafeek
.... Just an alternative:
=AVERAGE(LARGE(A1:A15,{1;2;3;4}))
--
regards/pozdrav!
Berislav
|