Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Advanced Filter Problems
Hi. I have a list of every zip code in the U.S. with various demographics.
I also have another list with about 500 zip codes that i want to filter with the first list to pull the corresponding demographics. I have the sheet set up correctly because i have used Advanced filter 100's of times. But this time when i run the filter, the whole original list (with EVERY zip code) is reproduced in the place where the filtered list should appear. I'm thinking that the zip code cells are not formatted the same (Like on one list they are text, and the other they are numbers). But i try to change the cell format so they are both numbers or both text, and i still get the wrong filtered list. Does anybody have any suggestions on how to get this to work? Thanks in advance. |
#2
|
|||
|
|||
Does one or the other have some leading or trailing spaces? Try doing
=LEN(A1)=LEN(B1) as a check (adjust to suit). -- HTH RP (remove nothere from the email address if mailing direct) "Brian" wrote in message ... Hi. I have a list of every zip code in the U.S. with various demographics. I also have another list with about 500 zip codes that i want to filter with the first list to pull the corresponding demographics. I have the sheet set up correctly because i have used Advanced filter 100's of times. But this time when i run the filter, the whole original list (with EVERY zip code) is reproduced in the place where the filtered list should appear. I'm thinking that the zip code cells are not formatted the same (Like on one list they are text, and the other they are numbers). But i try to change the cell format so they are both numbers or both text, and i still get the wrong filtered list. Does anybody have any suggestions on how to get this to work? Thanks in advance. |
#3
|
|||
|
|||
Thanks for the advice. I checked the len and it checked out fine. I ended
up just doing a copy and paste of the whole spreadsheet into a new spreadsheet, and it workd that time. Wierd stuff. "Bob Phillips" wrote: Does one or the other have some leading or trailing spaces? Try doing =LEN(A1)=LEN(B1) as a check (adjust to suit). -- HTH RP (remove nothere from the email address if mailing direct) "Brian" wrote in message ... Hi. I have a list of every zip code in the U.S. with various demographics. I also have another list with about 500 zip codes that i want to filter with the first list to pull the corresponding demographics. I have the sheet set up correctly because i have used Advanced filter 100's of times. But this time when i run the filter, the whole original list (with EVERY zip code) is reproduced in the place where the filtered list should appear. I'm thinking that the zip code cells are not formatted the same (Like on one list they are text, and the other they are numbers). But i try to change the cell format so they are both numbers or both text, and i still get the wrong filtered list. Does anybody have any suggestions on how to get this to work? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Filter Problem | Excel Discussion (Misc queries) | |||
Tricky ComboBox / Filter query | Excel Discussion (Misc queries) | |||
Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Filter changes upon reopening file! | Excel Discussion (Misc queries) |