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
amazeer ·