How to retrieve second last value of field in frontend?

[#1]

Hi experts,

I want to retrieve the row  which is above of the selected String or row in the column..

and also on clear selection that should be a second last String of the column .

plz give your suggetions...

Thanx in advance.

[settu_periasamy]

Hi,

Can you give the example or post the sample file and the expected output? It would help us to understand better.

[Kushal_Chawda]

Please provide sample data and expected output needed

[#4]

Hi

This is my expected output.

Plz have a look.

[settu_periasamy · Accepted solution]

Hi,

May be like this

[#6]

Thanx ur expression is working properly.,.,