Thread: Average formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
b&s b&s is offline
external usenet poster
 
Posts: 7
Default 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