"Calculate" and "Best" are a little vague.

Do you want to sum? average? the eight largest? smallest? smallest non-zero?
If there are less than 8 values, return error? return "insufficient data"?
use available data?
Is the data in rows or columns?

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"Steve Smyth" wrote in message
...
Hello I've been trying to find the formula to calculate the best 8 scores
from 11 results.
Scores are numbers from 0 to 130.
Can you help
Thanks

Steve