Autofilter advanced settings
Posted on 2013-02-06
I have copied and pasted a whol block of text out of a PDF document into Excel (2010).
I need to autofilter certain rows of this text but I am having an issue. The text is seperated into pages that contain either CO1, CO11, CO111. So if I just want to list pages with CO1, if I use a text filter on contains "CO1", its also picking up the CO11, CO111" also. Is there anyway to just filter for CO1, to avoid CO11 and CO111.
In addition, is there anyway at all to use an autofilter, to show the rows containing your text filter, plus the row immediately below it. I.e. if I filter for all rows containing CO11, it would be useful for it to show those rows plus to row immediately below those rows. Is that possible?