Previous Topic Next Topic

Auto Filter Issues

Closed
Leta - Nov 23, 2009 at 10:11 AM
 me - Apr 7, 2010 at 04:04 AM
Hello,
I am having issues with the auto filter in 2007 Excel. When I choose only certain information several other lines tend to hang on even though they do not meet the criteria of the filter. Example- I have a column that is only single letter identifier, I will choose to filter for A, and B but it brings up the some C's too. The C's are usually the last two to three lines of the spreadsheet and the newest entries. Even if I remove the C from the column it will still be included. This is very frustrating as it messes with the totals that I transfer to another report. Any idea how to stop this?
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 23, 2009 at 08:25 PM
how do you do autofilter for A AND b.
This means you want all the cells having either A or B.
when you click the arrow in the column heading you get download list
in that list click "custom"
in the custom window
first it
equals a
then choose OR
in the second window it should be
equals b
then click ok

you will get thelist both a AND b.
Answer 2 / 2
me
Apr 7, 2010 at 04:04 AM
You need to take the auto filter off and then put it back in again