Find last row in a column

[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

 

[Bernie Deitrick]

Insert a new row 1, and insert a header value. Then select that column, use Data Filter Autofilter
Select the dropdown, select Custom, use

is greater than or equal to 10

HTH,
Bernie
MS Excel MVP

 

[Don Guillett]

Did you want formulas?

formula to find value in cell q1=4
=MATCH(Q1,P,0)
formula to find the max larger than=14
=MAX((P1100>Q1)*(ROW(P1100)))
This one is an ARRAY formula that must be entered using ctrl+shift+enter