2

I have data in my excel sheet in the below format

A B
1 2
2 3
3 5
4 8
5
6
7
8
9

i.e colA has values 1 through 9 and colB has 2,3,5,8. Now what I need in col C is, the data in colA which is not there in colB .

So my result column C should have

C
1
4
6
7
9

Improve this question

1 Answer 1

Reset to default
2

I've haven't got excel at this computer but the basic idea is to use 

=IF(ISNA(MATCH(A1, B:B, 0));A1;"")

I'll check if this works in a couple of hours.

Explanation: Set the value of the current cell to value of A1 if there exists no cell in column B that has value that is an exact match to the value of cell A1.

Documenation: MATCH, ISNA, IF

Improve this answer
2
  • 1
    Yup. Seems to work. Though I'm using a localized version of excel in which the code looks like =JOS(ONPUUTTUU(VASTINE(A2;B:B;0));A2;"") where the row 1 contains the column headers.
    – Aleksi Yrtiaho
    Feb 18, 2011 at 10:04
  • Thank you very much Aleksi.. It did really worked.. Thanks alot
    – SrinR
    Feb 22, 2011 at 13:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .