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

"ferg" wrote:


Hi people
need a formula that will give the average of the highest 4 numbers in a
row of 10 to 12 cells. Hope that explains my prob.
First post here and hope to learn plenty
Thanx
:)


--
ferg
------------------------------------------------------------------------
ferg's Profile: http://www.excelforum.com/member.php...o&userid=36519
View this thread: http://www.excelforum.com/showthread...hreadid=562810