LOL - Aw shucks. You're too kind. I was happy to help. Let me know if you have any future Excel questions.
My favorite application was to create a spreadsheet that would take 21 golfers (and their handicaps) and create 7 teams of three for which:
(a) the team handicaps (sum of all 3 players) would not vary by more than an input value from the best team to the worst (say, no more than 3 strokes), and...
(b) the sum of the handicaps for the
top two players of each team would
also not vary by more than an input value (say, no more than 2 strokes), and...
(c) the spreadsheet must allow for changing these values as the user saw fit.
If my math is correct, there are several million combinations for creating 7 teams from 21 players. My spreadsheet can assign the required teams in several seconds, if a solution exists for the given criterea. That was obviously a slow day at work (heck, my
boss was the one who asked for the spreadsheet).
