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

    Comments

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

    Les

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

    Peter

    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. http://www.powerpivot.com/videos.aspx Cheers, June.

    Joko Susilo

    I've downloaded it. Thanks

    The comments to this entry are closed.