LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rc
 
Posts: n/a
Default macro or worksheet function?

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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Offset function referencing worksheet Jeff Excel Discussion (Misc queries) 1 September 11th 05 07:01 PM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM
Reference the worksheet from a multiple worksheet range function ( DBickel Excel Worksheet Functions 1 May 28th 05 03:49 AM
Executing macro for all worksheet from a different worksheet Biti New Users to Excel 3 December 8th 04 10:05 AM


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"