+ Reply to Thread
Results 1 to 5 of 5

Comparing 3 Values

  1. #1
    Registered User
    Join Date
    08-10-2010
    Location
    Lincoln
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    43

    Comparing 3 Values

    Hi all,

    I have 3 columns of scores written next to a name.
    I'd like a formula which can return the name that is written next to the largest of the three scores.
    Oh! and if all 3 scores are 0 it shouldnt display anything... and if all three scores are the same, can it say 'tie' or something like that?
    Can someone help?

    Thanks to anyone that can help
    Please see example file.
    Thank youuuu
    Attached Files Attached Files
    Last edited by nac1987; 12-02-2017 at 03:54 AM.

  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
    52,929

    Re: Comparing 3 Values

    This is probably way too simplistic, but lets start here.

    Maybe something like...
    =MAX(I3:I21)
    for Mike
    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
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Comparing 3 Values

    This seems to work....
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by davesexcel; 12-02-2017 at 07:14 AM.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,025

    Re: Comparing 3 Values

    Or this:

    =IF(LARGE(C3:I3,1)=LARGE(C3:I3,2),"Tie",INDEX(B3:H3,MATCH(LARGE(C3:I3,1),C3:I3,0)))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Comparing 3 Values

    Another way.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Matching values in two columns, then comparing values in adjacent cells
    By crfcaio in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-03-2017, 07:40 PM
  2. [SOLVED] Comparing Same Column to Column for Matches and then Comparing Offset Values
    By Exia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-01-2015, 12:00 PM
  3. [SOLVED] Macro to give the count of unique values after comparing the comma separated values
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2014, 12:41 AM
  4. Replies: 1
    Last Post: 10-01-2013, 02:41 AM
  5. Find missing values - based on looking up a list, comparing against index values
    By anakaine in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-22-2013, 01:31 AM
  6. Grouping rows based on column values and comparing row values
    By bernborough in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2010, 10:18 AM
  7. [SOLVED] Comparing values in two columns and displaying missing values in n
    By cpetta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2005, 11:29 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