Hi,

Yes

Set up a Criteria Area such as

Results Results
56 <65

Where Results corresponds to a title in your data area, and 56 and 65
correspond to the 5% under and 5% over values. You amy want to change to =
and <= but the idea is the same.

--
Thanks,
Shane Devenshire


"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!