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

help with excel

Discussion in 'BlackHat Lounge' started by nonai, May 2, 2014.

  1. nonai

    nonai Power Member

    Joined:
    Oct 10, 2013
    Messages:
    524
    Likes Received:
    63
    Here is a problem that I have while blog commenting.

    ok, so I scrape a bunch of pages to comment on. I find all PRs and sort by PR. so here is how my list looks:

    aaa.com/ddeed PR6
    bbb.com/nfddfd PR6
    ccc.com/djnnm PR6
    aaa.com/b4dfe PR5
    aaa.com/d3eee PR3
    bbb.com/skeie PR1

    when I comment on the first one, aaa.com/ddeed, I dont need to waste my time going through any more aaa.com blogs because aaa.com is already done. I want to have some kind of automated way to indicate aaa.com/b4dfe and aaa.com/d3eee are not necessary any more. maybe delete them, maybe highlight them. Basically, I need to delete or highlight any cell that contains aaa.com ... is this possible?
    I am also open to other suggestions.

    If you are wondering how I do it now, I just scroll up and see if I already commented on aaa.com and that's a big waste of time when you are doing this a lot.