Search results

A cosmetic modification; adding CF with color pattern for the winning golfers in SKINS tab and use font, AMERICAN TYPEWRITER since this font would stand out better if formatted bold for the winning low hole strokes in breaking a tie in the RESULTS tab...

Narayan, OK, I deleted by issuing the Edit> Clear > All to erase anything on AB10:AB25. Expanded the rows including formulas to 58 rows in the SKINS tab. I will give it another test run for this Tuesday's golf outing! Create a macro that would allow me to sort first the net...

Should I expand now to 56 rows in SKINS tab to accomodate the maximum allowable in RESULTS tab and use the HIDE command as you suggested before? Me puzzled likewise at the four names you mentioned. That is why I asked if that list is now orphaned as result or what? I am using Excel 2008 for...

I just did the thick borders on the SKINS tab, figuring that would be alright since all of the cells there are referenced from the RESULTS tab. Here is the example: https://www.dropbox.com/s/s71wgiovrp2rk3i/MasterNetSkins_R8d.xlsx

What a thrill! Since we have 56 fixed rows for golfers in RESULTS tab, whereas there are 27 possible golfer entries in the SKINS tab. Would it be straightforward to expand the number of rows there without upsetting the references in the SKINS tab? What about the list of names at AB10:25...

Faseeh, allow me to add a third scenario: After 17th hole, Team A is 'AS' with Team B, then win the last hole = the final result reads as '1 UP'. (the reverse of the first scenario above) Disregard my question on your dropping the 'AS' text value. I realized it is still there after another...

Looks good and a minor CF clean up with the color patterns for column C, also adding 6 rows more to make 56 rows total. Hence the version is R8b. I wish I could see the List Manager and fully understand how the formulas do in Columns AD through AH. Would RANK formula be useful for the...

Faseeh, You got it right! I noticed that you are eliminating the OUT and IN cells in your Sample workbooks. Was that helpful to simplify the formula writing in defining ranges? And the same holds true for dropping the 'AS' text value in the holes range? I just want to understand your...

If you have access to the Golf Channel on your TV, there is a World Match Play going on right now here in Arizona that will give you a clear idea how a match format is played.

In answering your confirmation/question post: 1. Yes the number of strokes determine how the hole is won or tied. But I would not give a 0.5 value for the AS. Only a 1 value for the win on which side of the team pair. 2. You correctly answer in B17 on how the game ends or may remain tied...

First of all, I realized the L23 and L28 should not have the IF formula. I stripped that and the rest of L cells in the workbook. Here is the update: https://www.dropbox.com/s/hjxivts4t6medj1/MatchFormat%20.xlsx I understand your appeal against the technical terms. I try to present it...

Let me add here: After the origiinal central question gets solved, we would test with each group in the workbook. Then we may use possibly a COUNTIF fomula in both V8 and V9. Each team win is worth one point and each team tie is worth a half point.

Hi Faseeh, What you see in the Group 2 with the nested IF formulas in C23:U23 (all 18 holes) for Team California and the same in C:28:U28 for Team Arizona; they are all simply return as the 1UP or AS for each adjacent cell and not the final 'win match' answer. Here the central question is...

In a golf game, playing the match format is determined by winning on a hole-by-hole basis. Unlike stroke play, in which the unit of scoring is the total number of strokes taken over one round of golf, match play scoring consists of individual holes won, halved or lost. On each hole, the most...

Oh, now you pointed out the culprit. Go ahead to move those two rows for the LOWEST HOLE STROKES and the NUMBER OF SKINS to Row 61 and 62. This will give me 50 golfers maximum. Typically it will be under 30 golfers total. I suppose I have to hide the unused rows manually per each outing...

Hi Narayan, Just to let you know my next golf outing will be Tuesday, February 26. Allow me to comment something here to see what is your thinking on the design: Were you taking time thinking on how to begin from a master file to handle the varying number of golfers that show up at each...

Here is what I used your R5 file to enter the results last Saturday and saved as this file: https://www.dropbox.com/s/yrbn6n5pupkt4gq/2013-02-09.xlsx Two points to answer you: 1. Funny that you asked me this question since you were the one who implemented the helper column in RESULTS tab...

Narayan, I am sorry for causing the confusion when you asked me for the recent results. 2013-01-09 is a spreadsheet without the indexing forumulas you have helped build. The entries there were done manually. The list of golfers for the Net Skins game is a subset of the golfers list in the...

Are you implying that leaving a cell blank is equivalent to a 0? Then I would prefer a different approach from putting a high number like 99. Because I would print the final product as a PDF and post on our golf website. See? I am reuploading the Revision5 file and one recent actual results...

We have two sets of games; the first one is mandatory for Net Result (Z15:Z43 in RESULTS tab) where everybody will chip in $5. The second game called Net Skins is optional and not everybody would want to participate in it. So the logic test seeks for those who chipped in $5 (AC15:43 in...

I have an idea how to deal with the golfers that do not participate in the Net Skins game. Can we do a logic test that test the cell for the data ($5) otherwise returns FALSE so the formula would not calculate the cells of those unpaid golfer(s). That is probably the fast and dirty way for...

I am unable to open this version; the error message says: This workbook contains content that is not supported by Excel 2008 for Mac. <bullet> Top 10 data filters. Now that I completed the 29 entries of golfers and their HCP for tomorrow's outing, I get a lot of broken cell...

Narayan, I am back home and just read your last two messages; I have yet seen the Name Manager and I don't think my Excel 2008 for the Mac has that. Any other way to see the cell ranges under those Names? And I was unable to understand nor duplicate your CF step with Bottom 1 and assign the...

Good grief, now that makes sense. I can see that works. But I do not find the named ranges, List_of_Golfers, Gross_Scores, and List_of_Tees. Can you show me where they are? I have answered my own conditional formatting question. It is easy to copy across the range. I am reuploading the...

Narayan, I added the ladies' hole handicaps in first place for you in R2 version. Did you mean it was not there after my latest file upload? And I did not see any change in any of the nested formula. Me puzzled right now since everything looked the same. Question on conditional formatting...