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

--
Message posted from http://www.ExcelForum.com