# Finding Second highest number

1. ## 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  Register To Reply

2. ## 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  Register To Reply

3. ## 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>  Register To Reply