ExcelBanter - 2nd highest value.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - 2nd highest value. (https://www.excelbanter.com/excel-programming/431312-2nd-highest-value.html)

Darren

2nd highest value.

Hello, I know using the Max function I can get the highest value in a
sequence of numbers. My question is, is it possible to find the 2nd, 3rd,
etc. highest values from the same squuence?

Niek Otten

2nd highest value.

Look in HELP for the LARGE() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darren" wrote in message
...
Hello, I know using the Max function I can get the highest value in a
sequence of numbers. My question is, is it possible to find the 2nd, 3rd,
etc. highest values from the same squuence?

All times are GMT +1. The time now is 02:00 AM.