golf league spread sheet

[ribs58]

I am trying to set up a spread sheet for my golf league.
Here's an example:

Member ___ Today's Score __ Net __ Current Handicap

John Smith _____75 ________ 70___________5
Bill Smith _____76_________71___________5
Tom Smith _____ 77_________72___________5
John Parks _____72_________66___________8
Bill Parks _____78 ________69 __________ 9
Tom Parks _____80 ________ 73__________ 7

...... and so on for 180 golfers

Now I figured out how to list lowest net scores for todays round int
an "A" Flight "B" Flight and a "C" Flight by splitting tota
golfers into 3 Groups from data above like so....

"A" Flight Winners

66 ???????? ?My question is how do I have names listed
___beside the low scores from the dat
above?
69 ????????
70 ????????
71 ????????
72 ????????
73 ????????

So that spread sheet will end up like this...

66 John Parks
69 Bill Parks
70 John Smith
71 Bill Smith
72 Tom Smith
73 Tom Parks

Thanks for any help they may be out there.

ribs58

 

[ianripping]

I would use a match query.

If your results are in col F

eg


66
69
70
71
72
73

Then in col G use:-

=INDIRECT("A"&(MATCH(A:A,F1,0))
and copy this down

HT

 

[Don Guillett]

try this to put the lowest of the 2 to the right one to the left of each
name
Sub lowgolf()
For Each c In Selection
c.Offset(, -1) = Application.Min(c.Offset(, 1).Resize(1, 2))
Next
End Sub

You might also want to look here for other golf questions.
http://tinyurl.com/2q5kk

 

[Stephen Rasey]

You must allow for duplicate scores.

My solution to these types of problems is to create a unique lookup value.
In this case I would use:
Net Score + Row(netscore)/10000

Member ___ Today's Score __ Net __ Current Handicap
LookupScore

John Smith _____75 ________ 70___________5 _______________70.0003
Bill Smith _____76_________70___________6_______________70.0004

when you sort the scores, Sort on the LookupScore and display it without
decmals.

Winners.
Row 10: 70.0003 =Lookup(A10, LookupScore, Member)
70.0004

Stephen Rasey
WiserWays, LLC
Houston, TX