I have an spreadsheet that I filter monthly using the advanced filter. It works perfectly every time until I added a new column header ("2014") to the next column to the right of the existing columns in my source spreadsheet and added the same column header (copying and pasting the header) to my criteria spreadsheet to the right of the last column in the criterion spreadsheet. I entered the new criteria in the 2014 criterion column (which actually should not match anything in the source spreadsheet because "2014" has just started and there are no entries in the 2014 source column. I also adjusted the date value for another criterion column which should limit the hits further than the previous setting. Now when I apply the advanced filter, very few records are being filtered. (I usually get 92 hits from 1267 records.) Now I'm getting 1205 hits from 1267 records. If I then delete both of the new columns added to the source and criteria spreadsheets--now the spreadsheets are identical to the spreadsheets that were working before--and use the advanced filter, I continue to get 1205 hits again. If I change the date criterion back to its previous values, I continue to get 1205 hits. I should be getting the 92 that I got before. If I revert to the original spreadsheet, the advanced filter works if the only thing I change is the date criterion. (I get 84 hits with the more stringent date criterion as I should.)
It seems that the spreadsheet becomes corrupted by simply added the column header in each spreadsheet.
It seems that the spreadsheet becomes corrupted by simply added the column header in each spreadsheet.
Last edited: