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
Bookmarks