Unfortunately, advanced filter's a bit beyond me, so, without a whole load
of study, I'll just have to go through the list and hide manually for now
Thanks anyway
"Dave Peterson" wrote:
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
|