Results 1 to 3 of 3

Thread: find the winner name from highest numbers

  1. #1
    Neophyte mwvirk's Avatar
    Join Date
    May 2013
    Posts
    4
    Articles
    0
    Excel Version
    2016

    find the winner name from highest numbers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need to ask another question here.

    since the highest number is resolved and also the runner-up. how can I take the names of the persons who got the highest and next to the highest person?

    I am splitting the sheet into 2 parts (i cannot install XL2BB on my office computer) sorry for this

    A Row (merged cell A3 to A13) (values in this range is unique) B Row (merged cell B3 to B13) (values in this range is NOT unique) C Row (merged cell C3 to C13) D Row (merged cell D3 to D13) (values in this range is unique) E Row (merged cell E3 to E13) F Row (merged cell F3 to F13) G Row (merged cell G3 to G13) H Row (merged cell H3 to H13) I Row (merged cell I3 to I13)
    NA # (2018) Province NA # (2013) Seat Name Registered Voters Total Cast Votes Rejected Votes Valid Cast Votes % Of Total Registered Votes
    NA-001 Area-1 NA-032

    (Tribal Areas IV)

    City-1
    City-1 318,150 245,602 500 245,102 77.20%












    J Row K Row L Row M Row N Row O Row P Row Q Row
    Candidate Name Party Votes % Of Candidate Votes Winner's Name Winner Party Runner up Name Runner up Party
    Candiate 001 Party 1
    18,000​
    7.34%
    Candiate 002 Party 2
    50,000​
    20.40%
    Candiate 003 Party 3
    19,000​
    7.75%
    Candiate 004 Party 4
    20,000​
    8.16%
    Candiate 005 Party 5
    50,001​
    20.40%
    Candiate 006 Party 6
    16,100​
    6.57%
    Candiate 007 Independent
    18,001​
    7.34%
    Candiate 008 Party 7
    21,000​
    8.57%
    Candiate 009 Independent
    8,000​
    3.26%
    Candiate 010 Independent
    5,000​
    2.04%
    Candiate 011 Party 8
    20,000​
    8.16%










    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,767
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    This has been cross-posted here: https://www.mrexcel.com/board/thread...mbers.1205474/

    You had our cross-posting rule explained to you last time you posted: https://www.excelguru.ca/forums/show...ull=1#post7498

    Please do NOT cross post without telling us again. Thanks.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,124
    Articles
    0
    Excel Version
    365
    In cell N3:
    Code:
    =IF(L3=MAX($L$3:$L$13),J3,"")
    O3:
    Code:
    =IF(L3=MAX($L$3:$L$13),K3,"")
    P3:
    Code:
    =IF(L3=LARGE($L$3:$L$13,2),J3,"")
    Q3:
    Code:
    =IF(L3=LARGE($L$3:$L$13,2),K3,"")
    All 4 cells copied down to row 13.

Posting Permissions

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