Skip to content
Aussieveedubbers

Geeks. Excel help wantd.

0 likes
Share Share on Facebook Share on X Share on Reddit

amazeer Bishop of Volkswagenism

3,029 posts · joined Nov 2005 ·

#716199
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

oldskl60 Officially Full-On Dubber

251 posts · joined Mar 2008 ·

#716279
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

amazeer Bishop of Volkswagenism

3,029 posts · joined Nov 2005 ·

#716282
works like a charm. Thanks 👍