Results 1 to 4 of 4

Comparing values to determine point which one value is greater and ends further comparison

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Tacoma, Washingtonn
    MS-Off Ver
    Excel 2019
    Posts
    254

    Comparing values to determine point which one value is greater and ends further comparison

    Greetings all,

    Thank you in advance if anyone could help me solve a formula problem. Golf knowledge is a plus! I am trying to automatically score match-play competition. I have attached a worksheet with 5 sets of players competing in pairs of 2. The hole columns (B-S) reflects the result of each individual hole played against each other, with a positive number indicating a win and a negative number indicating a loss. The other part of the hole results represents how many holes are left to play. When a player reaches a positive number which is larger than the number of holes left to play, the match is over. I am trying to find a formula to find that point in each matchup and record it under desired results. The losing player would remain blank.

    That's the easiest way I can think of to describe my project. Helping me solve this would save an enormous amount of time manually looking for that figure among as many as 140 players. I have had so much luck on this site, thanks for taking a look.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Comparing double values returns false - floating-point expressions
    By ericds in forum Excel General
    Replies: 7
    Last Post: 12-15-2014, 03:19 PM
  2. [SOLVED] Greater than doesn't work when comparing values from two textboxes
    By torppo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2014, 06:04 AM
  3. Scroll bar with a mid point of 0 and positive increasing values on both ends
    By jasonleewkd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2014, 06:21 AM
  4. Comparing multiple sets of columns for greater values
    By metsfan666 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-09-2012, 08:41 PM
  5. Replies: 6
    Last Post: 02-22-2012, 11:26 AM
  6. Comparing columns for values greater than each other
    By macaonghus in forum Excel General
    Replies: 5
    Last Post: 04-27-2009, 07:28 AM
  7. greater than comparison not doing anything
    By sulavsingh6 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2009, 02:56 PM

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