You could use the LARGE worksheet function and program in as many
formulas as numbers that you want to assess, then take the average of
the numbers that this gives you.

This wouldn't be very efficient though, you really need an array
formula and I aren't all that good at making them!


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=471491