Return several text and values that are in an interval

[danielhn]

Hi

I am trying to create a formula/VBA that will return the values (text and numbers) that are within a interval.

Fx

[TABLE="width: 120"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Adress [/TD]
[TD] Yield[/TD]
[/TR]
[TR]
[TD]test1[/TD]
[TD="align: right"]1%[/TD]
[/TR]
[TR]
[TD]test2[/TD]
[TD="align: right"]2%[/TD]
[/TR]
[TR]
[TD]test3[/TD]
[TD="align: right"]3%[/TD]
[/TR]
</tbody>[/TABLE]

If I search in the interval: 0.5% - 2% it should return
Adress Yield
test1 1%
test2 2%


Is there any way you can help me. Thank in advance
Daniel

 

[miss_ell]

Hello,

What about AutoFilter, would that help?

Choose Data, Filter then AutoFilter to get the drop-down arrows. In the Yield column, click on the arrow, choose Custom, and change to "Greater than or equal to" 0.5% AND "Less than or equal to" 2%.

 

[danielhn]

Hi - thanks for the answer.

Thanks, that would fix the problem but I am searching for something more user-friendly for novice users at my work who will be confused by all the steps = Need idiot-proof

 

[danielhn]

Please, any help out there?