Use of wildcards in advanced filtering.

[lorentzt]

I have an old macro that lets me do an advanced filter on a table orginating in SQL.
Because of a change in the values in the field i need to use wildcards.

Before i had values like below

Category
SmG
SmG/LTM
SmG/Trade

This was handlet with a filter that gave me all those with:
Category
SmG

New values are like: SmE/SmG/LTM and SmE/SmG/Trade. How do i get it to still search for SmG (but not just from the beginning of the value?)

Appriciate any help

 

[Andrew Poulsom]

Welcome to MrExcel.

Look here:

http://www.contextures.com/xladvfilter02.html#Number

The solution will also work for text within text.

 

[lorentzt]

Thanks for your quick answer. When i look at it in Excel 2013 i manage to do the check and to get it verified as true. But at first look i dont see how i can apply this to an advanced filter. Could be me .

I will give it a new try tomorrow morning.

Today i have a advanced filter that gets its values from parameters set on page one in my workbook. The resultet filter looks like this.
(Gives me all posts with type Change request that is posted before date "Posted" and eighter is not solved (empty) or solved before a given date. Firm starts wity Dyi and category starts with SmG)
[TABLE="width: 523"]
<tbody>[TR]
[TD]Type
[/TD]
[TD]Posted
[/TD]
[TD]Solved
[/TD]
[TD]Firm
[/TD]
[TD]Category
[/TD]
[/TR]
[TR]
[TD]Change Request
[/TD]
[TD]<=41944
[/TD]
[TD]>=41913
[/TD]
[TD]Dyi
[/TD]
[TD]SmG
[/TD]
[/TR]
[TR]
[TD]Change Request
[/TD]
[TD]<=41944
[/TD]
[TD]=
[/TD]
[TD]Dyi
[/TD]
[TD]SmG
[/TD]
[/TR]
</tbody>[/TABLE]

Welcome to MrExcel.

Look here:

http://www.contextures.com/xladvfilter02.html#Number

The solution will also work for text within text.