S
SPV
Hi I need some help to find out following
Select the range of a column depending on the last value of the same.
Then check the individual values of the column to match a threshold
value.
Select the range in which the values are more than threshold
Example
Column X
4 Let it be X1
6
8
10
12
14
16
18
20
22
24
26
28
30
8
6
4
2
..
..
..
n Let it be Xn
If I take threshold as 10 it should selct the range between value 10
and 30... ie, X4:X14
Can anybody help me...
Here in the Column x
Select the range of a column depending on the last value of the same.
Then check the individual values of the column to match a threshold
value.
Select the range in which the values are more than threshold
Example
Column X
4 Let it be X1
6
8
10
12
14
16
18
20
22
24
26
28
30
8
6
4
2
..
..
..
n Let it be Xn
If I take threshold as 10 it should selct the range between value 10
and 30... ie, X4:X14
Can anybody help me...
Here in the Column x