Advanced filters (+/-5%)
Hi
Yes you can.
Insert a couple of blank rows above your header row
Assuming the column that holds the values you want to filter upon is column
D and the first data value is in D4,
enter in A2
=D4=your_value*0.95
enter in B2
=D4<=your_value*1.05
In Advanced Filter, set your criteria range as A1:B2
--
Regards
Roger Govier
"Hotel_guy" wrote in message
...
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!
|