Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question
up vote 2 down vote accepted

With Excel 2010:

enter image description here

For 2003:

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

Your Answer


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.