PDA

View Full Version : Filtering



austenr
11-14-2006, 08:14 AM
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
11-14-2006, 09:15 AM
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
11-14-2006, 05:24 PM
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
11-14-2006, 05:28 PM
Hi Ken,

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