Filtering

P

Pam in California

I am working with a large worksheet (5436 rows) imported from Access. I want
to filter records based on zip code. I am using the custom filter feature to
find zipcodes (ie between 94901 and 95051). When I apply the filter no
records are shown although I know they are there. Is the size of the
worksheet too large? Is there a way I can get around this.

Thanks for the help.
Pam
 
P

Pete_UK

Your zip codes may be stored as text values, though they look like
numbers. You could add a new column and convert the values to numbers
then filter on this new column, or if you want to retain the codes you
have then in the custom filter pull-down you could try "begins with" -
doesn't always work with numbers, though.

Hope this helps.

Pete
 
Top