Results 1 to 7 of 7

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

Threaded View

  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

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