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