Second Max Value in Column Range (Straight Table)

[Anonymous]

Hi Guys,

Can you please advise me how can I get second or third max value in column range?

Col_1	Col_2	Col_3	Col_4	Col_5
10	20	30	40	50

Currently I am using RangeMax & RangeMin to get Max or Min value. But I get to get 2 or 3 from the range.

Kind regards,

Farrukh

[settu_periasamy]

Good to hear you fixed this. I didn't have a time to look this.

[Anonymous]

This has been done by your great help!

Thanks a mil again. ...

Farrukh

[rh_pg]

Hi Settu, I am looking for solution how to use RangeMax for columns which are named via Label.

My column is named TrfSlvnft via Label, whole column is calculation. But it looks like RangeMax does not want to work with custom named columns. I tried column(5) for example, did not work. Maybe I googled wrong, but I did not find solution in an hour. Could you help?

Example of name of my column:

how I want to use it:

does not work 😞