Hi!

Pair the teams on BestBall, and display the low net score of each hole
entered, as already calculated on SKINS.

That should be easy.

Have the ability to allow a player to be paired in multiple teams

I'd need more overview of just what that would entail!

I'm available for a project. If you want to send me your file I'll see what
I can do. If you're interested let me know how to contact you.

Biff

"rc" wrote in message
...
I'm probably getting in over my head with this, but I thought I'd ask
anyway,
so maybe I could learn from the answers that are generated.

I have a workbook that has several worksheets to track golfers' 18 hole
scores and the various competitions for low score per hole, as well as
net.

For my question here, the relative worksheets are ENTRY, SKINS, and
BESTBALL.

In the first column of the ENTRY page is a list of all players
(Entry!A4:A153).
In the 6th column, I use a value to flag a player as a member of a two-man
team, e.g., "bb1, bb2, bb3", etc.

The SKINS worksheet displays the players' net score per hole, based on
their
handicap.

BESTBALL worksheet is the new addition intended to pair the two-man teams
and display the low net score per hole for each team.

REQUIREMENTS:
- Identify 2-man teams by using the flags on the entry page.
- Pair the teams on BestBall, and display the low net score of each hole
entered, as already calculated on SKINS.
- Have the ability to allow a player to be paired in multiple teams.

So far, I'm able to pair teams on the BESTBALL worksheet, but I've not
been
able to compare their scores for each hole and display the lowest.

This is the formula I'm using to pair the players, thanks to Biff!
{=INDEX(Entry!$A$4:$A$153,SMALL(IF(Entry!$F$4:$F$1 53="bb"&ROWS($1:1),ROW(A$4:A$153)-ROW(A$4)+1),COLUMNS($A:A)))}

Also, I'm having trouble figuring out how to allow a player to be on
multiple teams. I assume that I would have to have more than one value to
indicate multiple teams, like bb1, bb2, bb3, for a single player. But my
attempts to make this happen break the functionality.

If anyone has a suggestion or two, that would be greatly appreciated.