Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: what formula?

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    mike
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to find highest number in, let's say J2:J25 and whatever cell has that number I want to put the persons name that's in A to a new cell and add two different cell so I get the result that looks like:

    Mike wins $15.00

    Can it be done with excel?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    NY
    Posts
    1,056
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sure -- =INDEX(A2:A25,MATCH(MAX(J2:J25),J2:J25,0))&" wins "&text(MAX(J2:J25),"$#,##0.00")

    Bob Umlas
    Excel MVP

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-27 17:47, meta182 wrote:
    I want to find highest number in, let's say J2:J25 and whatever cell has that number I want to put the persons name that's in A to a new cell and add two different cell so I get the result that looks like:

    Mike wins $15.00

    Can it be done with excel?
    Hi meta182:
    I took your sample data and placed in columns I and J as under
    columnI ColumnJ
    Mike 2.00
    Tiger 13.00
    Mark 9.00
    Mike 15.00
    Alan 11.00

    then the following formula gives the intended result:

    =INDEX(I2:I6,MATCH(MAX(J2:J6),J2:J6,0),1)&" Wins $"&TEXT(MAX(J2:J6),"00.00")

    Mike Wins $15.00

    HTH

    Please post back if it works for you ... otherwise explain a little further and let us take it from there!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Bob Ulmas:
    I may have posted while yours was on the way ... Great, neat and compact!

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    mike
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    this is my first experience with excel.

    Your answers are great Thank you Thank you Thank you

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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