MrExcel Publishing
Your One Stop for Excel Tips & Solutions

filtering a value rabge in autofilter

Posted by Dave Witt on January 24, 2002 11:35 AM

How do I filter a value range in autofilter? I'm using a pivot table to view invoices. some invoice numbers begin with a leter, A thru Z, and some are only numeric. I want to exclude any that begin with a letter. I tried choosing "does not begin with" and put A-Z in the critirea box, but it doesn't work. I can exclude them one letter at a time, but can't find a way to exclude all letters. Any suggestions? Thanks

Posted by Chris D on January 24, 2002 1:30 PM

Hi Dave,

if you only want numeric values, would filtering on anything greater than or equal to 0 (zero) do it ?

Posted by Dave on January 25, 2002 6:15 AM

Chris, thanks, yes that does it.