Find last row in a column
 

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

Find last row in a column
 

Pls post in ONE group only

--
Don Guillett
SalesAid Software

"SPV" wrote in message
oups.com...
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