Just another way...

If the list is large or changes often, sometimes I'll put it on another
worksheet.

Then I'll use another column in my filtered range.

=if(isnumber(match(a1,sheet2!a:a,0)),"Yes","No")

Then filter on that helper column.


novice wrote:

I have a range of random postcodes and want to filter some out. Using
Autofilter, I want to enter more than one postcode into 'contains': what
symbol do I use for 'and'? All I seem to be able to do is enter one postcode
in the first box and one in the other. 'Greater than' or 'less than' won't
work because I have 2-4, 6-7, 9-11 etc. You may gather that I'm not an
expert...would be grateful for any help!

--

Dave Peterson