Hi, best way is to insert a column with the formula as follow

Let's say the amount you want to compare is in cell A1 and the values to
compare down from A2

=+IF(AND(B24=D22,B24<=C22),1,0)
Then sort by 1 this column and you will have your values between that ranges


"Hotel_guy" wrote:

I'm wondering if it's possible to use the advanced filter function to create
a range option. Basically, I want to show all data which is between 5% over
a specific figure to 5% under a specific figure. I'm using Excel 2003. Is
this possible?

Thanks for your help!