filter email addresses

A

Angel

I have a database of emails that I'm trying to extract all email addresses
with certain domain.com criteria. I have the criteria range at the top as
email
="=*yahoo.com"
a blank row
email
data range below

I have followed all the instructions to the letter and am still not getting
any filtering. My data doesn't do anything.
 
A

Angel

yes, I figured out how to do it in auto, but how do I advance filter with
"contains"?
 
Top