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

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
 

jbsales

Registered Member
Joined
Feb 20, 2010
Messages
85
Reaction score
6
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.
 

zPro2010

Junior Member
Joined
Aug 4, 2010
Messages
163
Reaction score
40
Pay someone to make you a tool that does that?
 

zPro2010

Junior Member
Joined
Aug 4, 2010
Messages
163
Reaction score
40
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.
 

edgematch

Elite Member
Joined
May 24, 2010
Messages
2,543
Reaction score
1,970
Most text editors do that. Just search and find "all occurrences". notepad ++ is very handy for such a need.
 

Craive

Newbie
Joined
Sep 29, 2010
Messages
46
Reaction score
10
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:
 

bezopravin

BANNED
Joined
May 11, 2010
Messages
461
Reaction score
3,503
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
 

zbang

Newbie
Joined
Apr 23, 2009
Messages
16
Reaction score
1
this is very easy with excel. put your list in excel and then apply a filter with CONTAINS: KW1 and CONTAINS KW2
 

Janpower

Registered Member
Joined
Jun 15, 2010
Messages
56
Reaction score
11
You can use also MS acces that is made for problems like this one
 

remmaps

Regular Member
Joined
Apr 13, 2010
Messages
212
Reaction score
124
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
 
Top