Aussieveedubbers - General Chit Chat - Geeks. Excel help wantd.

Home

FAQ

Topic Activity Forum Stats

Stats

Banners

Last active: Never

Not logged in [ Log In - Register ]

Aussieveedubbers

General Chit Chat

Geeks. Excel help wantd.

[ Total Views: 575 | Total Replies: 2 | Thread Id: 76944 ]

« View Previous Thread

View Next Thread »

amazeer

A.k.a.: Surly Duff
Bishop of Volkswagenism

Posts: 3029
Threads: 387
Registered: November 14th, 2005
Member Is Offline

Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: bitter

posted on June 2nd, 2009 at 02:38 PM

Geeks. Excel help wantd.

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

Posts: 251
Threads: 28
Registered: March 9th, 2008
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue

posted on June 2nd, 2009 at 08:04 PM

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

http://4.bp.blogspot.com/_0YtLR7Gj2Tw/SlsMWR7pLcI/AAAAAAAAAAM/CDqzMEYH70E/S1600-R/oldskl60-footer1a.jpg

amazeer

A.k.a.: Surly Duff
Bishop of Volkswagenism

Posts: 3029
Threads: 387
Registered: November 14th, 2005
Member Is Offline

Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: bitter

posted on June 2nd, 2009 at 08:18 PM

works like a charm. Thanks :tu:

Aussieveedubbers

General Chit Chat

Geeks. Excel help wantd.

Powered by GaiaBB, © 2011 The GaiaBB Group
(C) 2001-2025 Aussieveedubbers

[ Queries: 40 ] [ PHP: 1.0% - SQL: 99.0% ]