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:
    64
    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.