Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble with Advanced Filter
G'day there One & All,
After much swearing, cursing & experiment - all ineffective - I'm now asking for assistance with my latest fiasco. I have a list of data which includes dates, text, and numbers but none combined, i.e. each column has only one of these types. There are 22 columns, but I need only about 12 as criteria. I've placed these above the data list with a couple of rows separating them. I have the data in a dynamic range labelled "Database", and the critera in a static range which I've named "Criteria". As you can see, I have a gift with inspired name assignments :) To ensure the criteria names are identical to the data column titles I have now applied a formula to each. These are simply "=A10" or whatever. I initially copied & pasted the headings, but had to rename a few so I did this in case I need to rename them again. Regardless, my filtering didn't work in either case. I have generated about 4 rows of dummy data of the same form that the real data will be. I then copied these 3 times to give 12 rows of data. The person's names are of the format 'SMITH A B'. Because of the duplication there are 3 records with that field entry. I have used 'SMITH' in the appropriate criteria column and then tried filtering. I found that this returned every record. Even those whose name is 'BROWN' or whatever. I have tried copying to another location and filtering in place, but with the same result each time. I've tried 'SMITH*'; '="=SMITH"'; '="=SMITH*"'; all with the same result - all records returned. This was when I used the entire criteria range of 11 columns with 3 rows, but only one criteria entered. I then used only that criteria. That is, I used only the two cells holding the heading & 'SMITH' as my criteria. This made a change, in that it returned the first record only. It did have 'SMITH' as the name, but the other records with this name were not returned. I have experimented with different date formats, and returned either all records or none. Even copy/pasting the date entry from the data to the criteria hasn't worked. I like to blame Microsoft for making faulty software, but I'm inclined to think that I've mucked this up by myself. I've searched the 'net but not found anything to assist. If anyone here has any ideas, please point them at me :D Thanks for listening, Ken McLennan Qld, Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
trouble with advanced filter | Excel Discussion (Misc queries) | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |