+ Reply to Thread
Results 1 to 3 of 3

Finding Second highest number

  1. #1
    Registered User
    Join Date
    03-01-2011
    Location
    Italy
    MS-Off Ver
    Mantova
    Posts
    31

    Finding Second highest number

    Hi

    I have data (numbers) in a row for 6 columns e.g. B2 to G2 have the following numbers (5,38,47,73,77,90). The numbers are from lowest to highest. The numbers can range from 1 to 99.
    The next row (row 3) will have dif numbers but always only 6 sets.e.g. (25,45,65,78,88.97) And so on for row 4 and so on.
    I am looking to find the highest number of each row. I used =max(B2:G2). That work and gave me the highest number which was 90. Now I would like to know the formula for finding the second highest number in each row. In this example it would be 77.
    The other info I would like is When the highest number is “x(90)”, what is the second highest number.

    Thank you
    Jaco

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Finding Second highest number

    Hi,

    maybe you could use if numbers are in a random order

    =large(b2:g2,2)

    if the numbers are in ascending order

    =F2 is the second one

    =G2 is the first one

    Regards
    Last edited by canapone; 01-27-2012 at 02:58 PM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Finding Second highest number

    Hi Jaco,


    I would need more information on 6 sets and x(90) etc.... would appreciate if you explain via an attachment. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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