|Use INDIRECT and MATCH to set the range for the LARGE function which will return the 2nd largest value in the new range.|
You didn't include Column letters, so I am going to assume that your values are in B1:B7.
To return 70:
To return 80:
In both cases MATCH(MAX(B1:B7),B1:B7,0) will return 3. The INDIRECT function will then use that 3 as the Row number to set the range for the LARGE function.
B1:B3 for 70 and B3:B7 for 80.
Since MATCH returns the Row number of the array searched, not the Row number of the sheet, you'll have to add an offset to the value returned by MATCH if your table starts in any Row other than 1.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.