Here's another question for the geeks. I run a social golf comp. The winner of each round gets 12 points, second gets 11 points, 3rd = 10 points etc etc.
There's 12 rounds in the comp and we're counting your best 8 results. In excel, how can I count the 8 best results in a column. Eg I want the column to look like this:

Chris
10
10
5
10
10
10
10
10
5
5
10
5
-----
80

Probably a better way, but this should work. Where "F10:F21" is Chris' data range...

=SUM(F10:F21)-SMALL(F10:F21,1)-SMALL(F10:F21,2)-SMALL(F10:F21,3)-SMALL(F10:F21,4)

Cheers
Tom

works like a charm. Thanks