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.
