Selecting variables based on values

[alion]

So I have some variables and their values like this:

AV1 2.3
AV2 1.2
AV3 3.0
AV4 3.1
AV5 2.5

Now if I want VBA to show me stocks with values between 2 and 3, it should give me AV1, AV3 and AV5 considering 3.0 was inclusive. How to do this? any clues?

thanks in advance

 

[John Davis]

So I have some variables and their values like this:

AV1 2.3
AV2 1.2
AV3 3.0
AV4 3.1
AV5 2.5

Now if I want VBA to show me stocks with values between 2 and 3, it should give me AV1, AV3 and AV5 considering 3.0 was inclusive. How to do this? any clues?

thanks in advance

Not sure if this helps, but if the list of variables are in Columns A and B maybe this?

Sub Alion()
Dim lr As Long
Dim lr2 As Long

lr = Cells(Rows.Count, 1).End(3).Row



With Range("C1:C" & lr)

    .Formula = "=IF(AND(B1>2,B1<=3),A1,"""")"
    .Value = .Value
    .AutoFilter
    .AutoFilter Field:=1, Criteria1:="<>"
    .SpecialCells(xlCellTypeVisible).Copy Range("X1")
    .AutoFilter
    
End With

lr2 = Cells(Rows.Count, 24).End(3).Row

MsgBox Join(WorksheetFunction.Transpose(Range("X1:X" & lr2)), vbLf)

End Sub

 

[alion]

thanks alot man... works fine...

 

[John Davis]

You're welcome. Thanks for the feedback.