Still wanting more information....

Largest 8 scores per person? Overall for all competitors?
Do you want them listed somewhere on the worksheet?
Do you need names associated with the top 8 scores?
How do you want to handle tie scores?

Meanwhile, see the LARGE function in Excel Help.

Is that something you can work with?

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

Regards,

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


"Steve Smyth" wrote in message
...
Thanks for your answer Ron.
They are Kart racing scores but the highest 8 only count towards the
championship.
So it's the eight largest and a non appearance at a round would be a zero.
Thanks

Steve
"Ron Coderre" wrote in message
...
"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