Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2016
    Posts
    14
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Need help. ASAP if possible

    Hi again!

    I need your help again guys.

    What i want is that in Cell B15 should show the column number that has the highest (in rank) percentage based on the array B13:G13. (i.e. if the highest percentage is in candidate 1 then the cell B15 should have number "1".

    I have attached my sample excel file for your reference.

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Try this:

    =MATCH(MAX(B13:G13),B13:G13,0)

  3. The Following User Says Thank You to kweaver For This Useful Post:

    tadzkie (2016-03-19)

  4. #3
    New Lounger
    Join Date
    Mar 2016
    Posts
    14
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thank you Kweaver!!!

    You're a big help!

Posting Permissions

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