How Do I Sort a List of 10,000 Keywords??

J

jbsales

Registered Member
Joined
Feb 20, 2010
Messages
85
Reaction score
6
Ok So I have a list of 10,000 keywords. Is there a way that i could sort them according to the words that are in it?? For example how can i find in that list all the keywords that have keyword 1 and keyword 2 in them?? Or How can I sort that list so it only shows all the keywords that have say "keyword 1" and "keyword 2"

Thanks
 
Advertise on BHW
Is there a way with excel that i could do this?? I just want to be able to pull keywords from a list of 10,000 that contains keyword 1 and keyword 2 in them. I know this can be possible.
 
It might be able to be done that way, I honestly have no idea, just throwing out what I would do if I needed a tool like this. I'm sure someone would do it for cheap.
 
Most text editors do that. Just search and find "all occurrences". notepad ++ is very handy for such a need.
 
If your list is already in excel, it's pretty simple. Lookup the formula for vlookup(). That's what you want. Nest an if else statement in there and you're set. Also index and match may work. Just google a lookup and sort function for excel and you should find what you need. :cool:
 
This can be done in excel. You should be able to apply advanced filters to do this.
 
Check out my Short Video Tutorial on how to do this in notepad++

http://www.blackhatworld.com/blackhat-seo/blackhat-lounge/300434-editing-big-list-how-remove-certain-urls.html#post2713519
 
this is very easy with excel. put your list in excel and then apply a filter with CONTAINS: KW1 and CONTAINS KW2
 
You can use also MS acces that is made for problems like this one
 
Hi

I made a simple excel file for you

In col A put your keywords copy all formulas to the end of your list

In cells D1, E1 etc (green ones) put your keywords that you want to find. copy the formula from cell E1 to the end (right and down)

In col B the TRUE mean that the ALL keywords exist in the phrase in col A
In col C the TRUE mean that ANY of the keywords exists in the phrase in col A

If you have any questions ask

here is the link to the file

mediafire.com/?8b44x9nujbgg6tf

the virus total website is not available right now. if somebody is able to load the virustotal please provide link to the scan result 10x
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Networking Downloads

Marketplace

Content / Copywriting Hosting Images, Logos & Videos Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design Misc

Making Money

Affiliate Programs Hire a Freelancer Making Money Pay Per Click Site Flipping

BlackHatWorld

BHW Merch Forum Suggestions & Feedback Introductions Lounge Dispute Resolution

Other

Domain Name Forum IM Journeys Web Hosting Newsletter
Back
Top