Yep, you can do a countif function.
So countif(ref to B, column A) and it'll return the number of instances that B appears in column A.

Then you can an autofilter to screen out those that have or don't have duplicates - filter for those more or less than 0.

To clean up your data first so that column A and B match same format of names, you have to split up B to match A. So in our Adv Excel for Data Analysis class we teach you a combination of left, right, and len functions. http://www.wallst-training.com/self-stu ... tech-excel... To clean up your data first so that column A and B match same format of names, you have to split up B to match A.

So in our Adv Excel for Data Analysis class we teach you a combination of left, right, and len functions.
http://www.wallst-training.com/self-stu ... tech-excel Read More