Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using autofilter, how do I enter several random postcodesinto 'co.
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! |
#2
|
|||
|
|||
The Autofilter criteria boxes only accept one criterion each, there's no
symbol for expanding that. Check out Advanced Filter in XL Help, and see Debra Dalgleish's site: http://contextures.com/xladvfilter01.html In article , 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! |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Thanks anyway
"JE McGimpsey" wrote: The Autofilter criteria boxes only accept one criterion each, there's no symbol for expanding that. Check out Advanced Filter in XL Help, and see Debra Dalgleish's site: http://contextures.com/xladvfilter01.html In article , 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! |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) |