+ Reply to Thread
Results 1 to 7 of 7

Highlighting Lowest Score W/O duplicates Highlighting and Counting player skins

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    north dakota
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Highlighting Lowest Score W/O duplicates Highlighting and Counting player skins

    I found this spreadsheet on here and I have been trying to customize it to what I need. I am trying to have scores from skins match highlighted. I want only the minimum score to be highlighted but if there is another duplicate minimum score I don't want it to highlight anything.
    I also need to find a way to count the skins won by each player and have it off to the side.

    For those not familiar with golf a Skin is a game where you try to get the lowest amount of strokes on a specific hole. Ex- 4 people play the hole one. P1 scores 4, P2 gets a 3, P3 and P4 get 6. The skin would go to P2 who has the lowest score on that hole.

    Detail of what I need help with:

    Highlight lowest number in each column not highlighting if there are duplicates starting at L6 down to L11 and for each column till AC. And the same for the group just to the right on attached file.

    On row 13 and 14 it tells me who won a skin. I want to tally up the total skins won by each player. so if Joe's names shows up twice on R14 I want it to tell me somewhere in the sheet Joe = 2
    Attached Files Attached Files
    Last edited by frieser; 02-16-2013 at 01:17 AM. Reason: added explanation about golf skins game

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Highlighting Lowest Score W/O duplicates Highlighting and Counting player skins

    Hi and welcome to the forum

    For those of us who do not play golf and know nothing of what a skins is, you may have to be a bit more detailed in your explanation and requirements?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-14-2013
    Location
    north dakota
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Highlighting Lowest Score W/O duplicates Highlighting and Counting player skins

    Thanks for the tip and the welcome to the forum. Excel has the power to do what I want, I just need to figure out how make it work. I updated my post so that should help I hope.

  4. #4
    Registered User
    Join Date
    02-14-2013
    Location
    north dakota
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Highlighting Lowest Score W/O duplicates Highlighting and Counting player skins

    UPDATED FILE

    I got the cells to highlight the lowest number in the column, now i need help getting rid of the highlight for columns with two low numbers.
    Attached Files Attached Files

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Highlighting Lowest Score W/O duplicates Highlighting and Counting player skins

    you want F and I highlighted for the lowest score, but if there is a repeat, dont highlight the 2nd (or more) 1? so there will only be 1 cell highlighted?.

    1. highlight the range you want to apply the conditional formatting to
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =IF(COUNTIF($F$6:F6,MIN(F$6:F$11))>1,FALSE,F6=MIN(F$6:F$11))
    Last edited by FDibbins; 02-16-2013 at 02:25 AM.

  6. #6
    Registered User
    Join Date
    02-14-2013
    Location
    north dakota
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Highlighting Lowest Score W/O duplicates Highlighting and Counting player skins

    That did work to eliminate duplicate min values, but it eliminates the same values in the rows as well. I need it to just look for min value in the columns. This then separates it per hole.

  7. #7
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Highlighting Lowest Score W/O duplicates Highlighting and Counting player skins

    here is a skin score card that I picked up here. It will display payout per skin when $ value entered
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1