macro or worksheet function?

[Guest]

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$153="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.

 

[Biff]

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

 

[Guest]

I attempted to contact you at the address shown in your profile, but it came
back undeliverable.

 

[Biff]

I attempted to contact you at the address shown in your profile, but it
came
back undeliverable.

Yeah, that's a bogus address for the bots!

Since you don't want to post your address..........

xl can help at comcast period net

Remove can, the spaces and change the obvious.

Biff