Excel help (1 Viewer)

[main-man]

Hi there

i no this is an access forum but i guess a lot of u guys r excel experts to.

what i need to know is this...

i havea spreadsheet with a list of postcodes e.g "DN14 4TH" and have been given the task of searching and extracting various postcodes. i Have to therefore find all the "DN15, DN16, DN38" postcodes from the list. im using autofilters but searching for each posdt code 1 at a time with the "begins with" field on the autofilers.

could some one tell me a way i could search for them all once quicker, rather than each time.

Hope u can help

Many thanks

 

[Guus2005]

Create a query:

Select * from postcodes where postcode like "DN*"

Gives you all zipcodes started with DN.

Veel plezier!

 

[main-man]

but what if i want dn7, dn9, dn21? how do i write it inthe autofilter box?

as it wont allow me to put dn7*, dn39*

 

[neileg]

Excel only supports 2 constraints in an autofilter, so you can't do what you are asking for. You could try an advanced filter but this is not so friendly as the autofilter.

 

[main-man]

ok thanks mate...u always come to my rescue. cheers