+ Reply to Thread
Results 1 to 4 of 4

Post the Name of Who Has Highest Number

  1. #1
    Registered User
    Join Date
    12-21-2012
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Post the Name of Who Has Highest Number

    I have an assignment and it is an excel of a fundraiser. It shows the participants names through cells A3 to A10 and their totals are in J3 to J10. I have attachd the spreadsheet and it is in Sheet 2. I think the winner has to be posted in the cell right beside their total and will only be posted of they are the winner, otherwise it is left blank. I'm new to excel however was able to figure out the rest of the functions through google and this forum so I have tried searching! I appreciate all of the help!

    Lab1.xlsx
    Last edited by tristangemus; 01-25-2013 at 04:51 PM.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Post the Name of Who Has Highest Number

    In K3 use

    Please Login or Register  to view this content.
    copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Post the Name of Who Has Highest Number

    Hi Tristangemus,

    Try:

    =IF(J3=MAX(J$3:J$10),"Winner","")

  4. #4
    Registered User
    Join Date
    12-21-2012
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Post the Name of Who Has Highest Number

    Thanks everyone, worked out great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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