Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
Row filtering based on input box entry (column heading) | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
avanced filtering for latest date | Excel Discussion (Misc queries) |