1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Black Hat SEO' started by jbsales, Apr 25, 2011.

  1. jbsales

    jbsales Registered Member

    Joined:
    Feb 20, 2010
    Messages:
    85
    Likes Received:
    6
    Location:
    Edmonton AB
    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
     
  2. jbsales

    jbsales Registered Member

    Joined:
    Feb 20, 2010
    Messages:
    85
    Likes Received:
    6
    Location:
    Edmonton AB
    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.
     
  3. zPro2010

    zPro2010 Junior Member

    Joined:
    Aug 4, 2010
    Messages:
    163
    Likes Received:
    40
    Occupation:
    hustler
    Pay someone to make you a tool that does that?
     
  4. jbsales

    jbsales Registered Member

    Joined:
    Feb 20, 2010
    Messages:
    85
    Likes Received:
    6
    Location:
    Edmonton AB
    Sure if I had the time and money to do that. I'm sure this can be done with excel, i'm just not sure of the formula
     
  5. zPro2010

    zPro2010 Junior Member

    Joined:
    Aug 4, 2010
    Messages:
    163
    Likes Received:
    40
    Occupation:
    hustler
    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.
     
  6. edgematch

    edgematch Elite Member

    Joined:
    May 24, 2010
    Messages:
    2,539
    Likes Received:
    1,949
    Occupation:
    You can never guess!
    Location:
    :noitacoL
    Most text editors do that. Just search and find "all occurrences". notepad ++ is very handy for such a need.
     
  7. Craive

    Craive Newbie

    Joined:
    Sep 29, 2010
    Messages:
    46
    Likes Received:
    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:
     
  8. Cnotey

    Cnotey Power Member

    Joined:
    Jun 25, 2010
    Messages:
    707
    Likes Received:
    912
    Location:
    Seattle
    Home Page:
    This can be done in excel. You should be able to apply advanced filters to do this.
     
  9. bezopravin

    bezopravin BANNED BANNED

    Joined:
    May 11, 2010
    Messages:
    461
    Likes Received:
    3,471
    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
     
  10. zbang

    zbang Newbie

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

    Janpower Registered Member

    Joined:
    Jun 15, 2010
    Messages:
    56
    Likes Received:
    11
    Occupation:
    Daytime: student, Nighttime: IM
    Location:
    Netherland
    You can use also MS acces that is made for problems like this one
     
  12. remmaps

    remmaps Regular Member

    Joined:
    Apr 13, 2010
    Messages:
    212
    Likes Received:
    123
    Home Page:
    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