I want to filter out domains that don't end in .com, .org or .net

**charlielivingston** · 03-19-2013, 03:36 PM

I have a huge list of domains (a million, in total) in two columns. Column A is just a list of numbers from 1 to 1,000,000. Column B contains the domains.

I want to filter this list so that ONLY domains ending in .com, .net and .org are displayed. Basically, I'm only interested in the domains that end in .com, .net or org.

Using the autofilter I can only filter by two of those things, not all three. I've looked into advanced filtering, but can't work out quite how to do it.

Can anyone help? I would be incredibly grateful!

You can grab the domain list here: http://s3.amazonaws.com/alexa-static/top-1m.csv.zip

It's Alexa's top one million domains.

**judgeh59** · 03-19-2013, 03:55 PM

=OR(RIGHT(A1,4)=".org",RIGHT(A1,4)=".net",RIGHT(A1,4)=".com")

this is give you a TRUE or FALSE and you can filter on that....HTH

**charlielivingston** · 03-19-2013, 04:24 PM

Originally Posted by judgeh59

=OR(RIGHT(A1,4)=".org",RIGHT(A1,4)=".net",RIGHT(A1,4)=".com")

this is give you a TRUE or FALSE and you can filter on that....HTH

It works! Thank you so much.

**judgeh59** · 03-19-2013, 04:26 PM

my pleasure....as you are new to the Forum....ettiquette recommends setting the status to SOLVED....you can do that by using the thread tool drop down at the top of the thread...Also, giving a star to person/persons that helped....and in the future when you help someone, they'll give you a star....have a great day....