Results 1 to 6 of 6

Thread: Someone help me find the right formula

  1. #1

    Exclamation Someone help me find the right formula



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

    Hi all,

    I'm kind of knows as the Excel wizard at work and have been given a challenge by a colleague which I just cannot crack!

    So we have a colums with team names and a colum with points for that team.

    I need a formula which will figure out who the highest scoring team is and then give me the name of the team in the column next to it.

    Does that make sense??

    Someone please help, I feel like I will lose a lot of sleep over this :(

    Cheers,
    Yasmine

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,599
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Highest score : use the MAX function ( say in col B)
    Name of the team try =INDEX(A1:A100,max(B1:B100)) say teams are in col A

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    792
    Articles
    0
    Excel Version
    2010
    Is this what you are wanting?
    Attached Files Attached Files

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    792
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Pecoflyer View Post
    Highest score : use the MAX function ( say in col B)
    Name of the team try =INDEX(A1:A100,max(B1:B100)) say teams are in col A
    Think you need MATCH working with MAX to return a row number, don't you?

  5. #5
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,599
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Absolutely right must have been sleeping

  6. #6
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    792
    Articles
    0
    Excel Version
    2010
    LOL

Posting Permissions

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