Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I use autofilter to hide random postcodes?
I'm sure this can be done but I can't work it out: I have list of postcodes
and wish to filter some groups out by the first two letters and number, e.g. XY1..., XY5...ETC. If I choose the 'contains' option I only seem to be able to filter one postcode in the first box and another in the 'and' box. What I want to do is enter all the postcodes in the first 'contains' box but, whatever symbol I try to use for plus,it doesn't work. Using the 'greater' or l'ess than' options won't work either as it will miss postcodes in the middle, e.g. if I wanted 2-4, 5-6, 8-10 etc. Can the programme do what I want/am I just thick? Grateful for any advice |
#2
|
|||
|
|||
Hi Mike,
You received responses several hours ago, from JE McGimpsey and Dave Peterson, to this question when you posted to the Misc group. Did you attempt to implement their suggestions? --- Regards, Norman " wrote in message ... I'm sure this can be done but I can't work it out: I have list of postcodes and wish to filter some groups out by the first two letters and number, e.g. XY1..., XY5...ETC. If I choose the 'contains' option I only seem to be able to filter one postcode in the first box and another in the 'and' box. What I want to do is enter all the postcodes in the first 'contains' box but, whatever symbol I try to use for plus,it doesn't work. Using the 'greater' or l'ess than' options won't work either as it will miss postcodes in the middle, e.g. if I wanted 2-4, 5-6, 8-10 etc. Can the programme do what I want/am I just thick? Grateful for any advice |
#3
|
|||
|
|||
Apologies, this is a repeat of a question I posted in general queries earlier
that I didn't think had got through. I have the answer: I can't and I'm going to have to learn more about advanced filter " wrote: I'm sure this can be done but I can't work it out: I have list of postcodes and wish to filter some groups out by the first two letters and number, e.g. XY1..., XY5...ETC. If I choose the 'contains' option I only seem to be able to filter one postcode in the first box and another in the 'and' box. What I want to do is enter all the postcodes in the first 'contains' box but, whatever symbol I try to use for plus,it doesn't work. Using the 'greater' or l'ess than' options won't work either as it will miss postcodes in the middle, e.g. if I wanted 2-4, 5-6, 8-10 etc. Can the programme do what I want/am I just thick? Grateful for any advice |
#4
|
|||
|
|||
Hi Norman
See the other post - duplication because I thought other post hadn't got through: original replies v. helpful. Regards Mike " wrote: I'm sure this can be done but I can't work it out: I have list of postcodes and wish to filter some groups out by the first two letters and number, e.g. XY1..., XY5...ETC. If I choose the 'contains' option I only seem to be able to filter one postcode in the first box and another in the 'and' box. What I want to do is enter all the postcodes in the first 'contains' box but, whatever symbol I try to use for plus,it doesn't work. Using the 'greater' or l'ess than' options won't work either as it will miss postcodes in the middle, e.g. if I wanted 2-4, 5-6, 8-10 etc. Can the programme do what I want/am I just thick? Grateful for any advice |
#5
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Can I AutoFilter an entire workbook? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) | |||
Using autofilter, how do I enter several random postcodesinto 'co. | Excel Discussion (Misc queries) |