ExcelBanter - Advanced Filter & Wild Cards?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Advanced Filter & Wild Cards? (https://www.excelbanter.com/excel-discussion-misc-queries/227915-advanced-filter-wild-cards.html)

Ken

Advanced Filter & Wild Cards?

Excel2003 ... Advanced Filter & Wild Cards?

"Criteria" is set as an "OR" 1234 ... & All is well

Now I wish to set "Criteria" as an "OR" ... & return all records beginning
with "12" (instead of just "1234") from the 2 subject Criteria Cols.

How do I do this? ... Thanks ... Kha

Ken

Advanced Filter & Wild Cards?

I got it ... ="=12*" ... Thanks ... Kha

"Ken" wrote:

Excel2003 ... Advanced Filter & Wild Cards?

"Criteria" is set as an "OR" 1234 ... & All is well

Now I wish to set "Criteria" as an "OR" ... & return all records beginning
with "12" (instead of just "1234") from the 2 subject Criteria Cols.

How do I do this? ... Thanks ... Kha

All times are GMT +1. The time now is 01:14 PM.