Advanced Filter with wildcards, Excel 2013

[redrockmtn]

[FONT=&quot]I have an Excel list with many websites. Some end in .com, .net, .org. But some end in .com.mx, .fr, .ru. How do I do an advanced filter to remove all .com.mx, .fr, and .ru while keeping all .com, .net, and .org?[/FONT]

 

[Marcelo Branco]

Example typing in A2
="=*.com"

Before filter

[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

A​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

Text​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

=*.com​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td]

Text​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td]

blh.com​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

6​

[/td][td]

blu.com​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

7​

[/td][td]

nju.com.fr​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

8​

[/td][td]

gfty.com.br​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

9​

[/td][td]

xxx.com​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

10​

[/td][td]

ght.net​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

11​

[/td][td]

juy.org​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

12​

[/td][td]

fff.com​

[/td][/tr]
[/table]

Apply advanced filter (List range:$A$4:$A$12; Criteria range: $A$1:$A2)


[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

A​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

Text​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

=*.com​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td]

Text​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td]

blh.com​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

6​

[/td][td]

blu.com​

[/td][/tr]
[/tr]
[/tr]

[tr][td="bgcolor: #DCE6F1"]

9​

[/td][td]

xxx.com​

[/td][/tr]
[/tr]
[/tr]

[tr][td="bgcolor: #DCE6F1"]

12​

[/td][td]

fff.com​

[/td][/tr]
[/table]

M.

 

[redrockmtn]

Thanks Marcelo, that did the trick. I was looking for that exact type of wildcard sequence.

Example typing in A2
="=*.com"

Before filter

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]

A​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

1​

[/TD]
[TD]

Text​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

2​

[/TD]
[TD]

=*.com​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

3​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

4​

[/TD]
[TD]

Text​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

5​

[/TD]
[TD]

blh.com​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

6​

[/TD]
[TD]

blu.com​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

7​

[/TD]
[TD]

nju.com.fr​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

8​

[/TD]
[TD]

gfty.com.br​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

9​

[/TD]
[TD]

xxx.com​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

10​

[/TD]
[TD]

ght.net​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

11​

[/TD]
[TD]

juy.org​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

12​

[/TD]
[TD]

fff.com​

[/TD]
[/TR]
</tbody>[/TABLE]


Apply advanced filter (List range:$A$4:$A$12; Criteria range: $A$1:$A2)


[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]

A​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

1​

[/TD]
[TD]

Text​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

2​

[/TD]
[TD]

=*.com​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

3​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

4​

[/TD]
[TD]

Text​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

5​

[/TD]
[TD]

blh.com​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

6​

[/TD]
[TD]

blu.com​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

9​

[/TD]
[TD]

xxx.com​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

12​

[/TD]
[TD]

fff.com​

[/TD]
[/TR]
</tbody>[/TABLE]


M.