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.

Is it possible to extract in a new column, the difference between two other columns, for example:

COLUMN A    COLUMN B
--------    --------
A7901RXW    A7901RKH
A7901RXX    A7901RKI
A7901RY3    A7901RXW
A7901RY4    A7901RXX
A7901R4V    A7901RY3
A7901R4V    A7901RY4
A7901R4V    A7901R4V
A7901S25    A7901R4V
A7901YQB    A7901R4V
A7901YQD    A7901S25
A7901YQ7    A7901S3Z
A7902AD0    A7901S3Z
A7902A0V    A7901YQB
A7902A0V    A7901YQD
A7902A1E    A7901YQ7

Any idea to reconigze easily which cells values we can find in column A but not in column B and vice versa?

In the example:

A7901RKH
A7901RKI
A7901S3Z
A7901S3Z
ect...
share|improve this question

1 Answer 1

up vote 2 down vote accepted

You need to use VLOOKUP function. Check out the following pages to learn how to use it: [1],[2],[3].

Note: Good examples are given on the above pages.

share|improve this answer
    
very useful, thanks! –  mcha Dec 3 '10 at 15:44
    
You're welcome. –  Mehper C. Palavuzlar Dec 3 '10 at 15:47

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.