Filtering

[austenr]

Is there a way to filter records in a range? What if I want to filter records that fall in a range from -10% to +10%. I don't see a way to do that using filter or advanced filter. Thanks :dunno

[Remalay]

Courtesy of Wrox, try the attached as a guide - it may help.4261

Principally the formulas in C2 & C3 act upon the criteria in D2 & E2

rgds
remalay

[Ken Puls]

Austen,

If you have a "helper" column with the percentage in it, why not apply an Autofilter with a custom setting of Greater than or Equal to -10% and Less than or Equal to 10%?

[austenr]

Hi Ken,

I found that which you show from above. Could not get back to post that I did though. Thanks.