Adance Filter that "CONTAINS"

  • Thread starter Thread starter HeartMom
  • Start date Start date
H

HeartMom

Hello I need your help. I will warn you now, that I am new here and may not
know the EXACT terminology so please bare with me.

I am trying to use an advanced filter that contains specific numbers... The
text string looks something like these.

0002267 A HANSEN RICE 1542 Nonresidenti
0003936 I TITAN INDUST 3559 Special Indu
0006108 A GEA POWER CO 1711 Plumbing, He

I need to be able to filter on specific ones like 1542 & 1711...

Thank you VERY much for your help.
 
I am assuming you know the basics as how to set up the criteria range with
headers etc. To get 1542 you can use

* 1542 *


assuming there is a space before and after will find all entries that have
1542 in the string. If you want entries with either those 2 you can setup
the criteria like this

Address Address
* 1542 *
* 1711 *



replace Address with whatever header you use, note that OR filtering then
you use the next value one cell below so if you have 3 different values you
would use a criteria that is another header and the next value another row
below so the whole area would cover 3X4 cells

--


Regards,


Peo Sjoblom
 
I am assuming you know the basics as how to set up the criteria range with
headers etc. To get 1542 you can use

* 1542 *


assuming there is a space before and after will find all entries that have
1542 in the string. If you want entries with either those 2 you can setup
the criteria like this

Address Address
* 1542 *
* 1711 *



replace Address with whatever header you use, note that OR filtering then
you use the next value one cell below so if you have 3 different values you
would use a criteria that is another header and the next value another row
below so the whole area would cover 3X4 cells

--


Regards,


Peo Sjoblom
 
Back
Top