If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adance Filter that "CONTAINS"
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. |
#2
|
|||
|
|||
Adance Filter that "CONTAINS"
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 "HeartMom" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|