My Photo

Twitter Updates

    follow me on Twitter

    « Career Advancement for Veteran Web Analysts (Article and Slides) | Main | How to Get Bounce Rate for Google Website Optimizer A/B Test Variations »

    June 30, 2010


    TrackBack URL for this entry:

    Listed below are links to weblogs that reference How to Compare 2 Lists of URLs Using Excel:


    Feed You can follow this conversation by subscribing to the comment feed for this post.


    Thanks for this informative article June. I'll be sure to try things out when I get a chance.


    this type issue arises all the time, and Excel is particularly ill-suited to solve it. I normally do it by using vlookup(textToFindFromListA, ListB,column) which would return the identical string sought, if found, otherwise return an error.

    I think PowerPivot and DAX might be the best way to do it going forward, in the absence of a custom VBA function.

    June Dershewitz

    Thanks for the feedback, Peter! Ive used vlookup in the past, as well. The thing I like about my solution is that its bi-directional - youd have to do two vlookups to see the outliers in each group.

    I haven't used PowerPivot and DAX but they sound like promising tools as ongoing (or high-volume) solutions. Ive just spent a few minutes of amusement watching the overview videos on their site. Cheers, June.

    Joko Susilo

    I've downloaded it. Thanks

    The comments to this entry are closed.