Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Excel document with two columns of data. I'd like to quickly see what values in column A exist in column B.

For example, imagine column A had the list of US President last names and column B had a list of the names of the states in the United States.

I'd like to see that the value "Washington" exists in both columns A and B.

Thanks

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

With Excel 2010:

enter image description here

For 2003: http://www.techrepublic.com/blog/msoffice/how-to-find-duplicates-in-excel/842

share|improve this answer
    
Wonderful, thank you for your answer - spot on. –  Scott Mitchell Aug 29 '11 at 16:41
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.