Help comparing 2 columns..

  • Thread starter Thread starter CHR
  • Start date Start date
C

CHR

I have two coloumns of numbers, which i need to compare. The Excel document
should come out with 3310 as a result in coloumn 3 (see exsample).

Can someone help me? I am dont know anything about VB programming in Excel,
so I hope someone can find a solution without any programming.

example:

Coloumn 1
2211
5510
2210
9952

Coloumn 2
2211
5510
3310
2210
9952
 
Sample:
With Range A1:A4 named "Rge1" ' equal to your Column 1 data.
and with your existing data in Column 2 - Cells B1:B5
In cell C1 enter:
=IF(COUNTIF(Rge1,B1),"",B1)
and copy down.
Column C should reflect any missing items in Col 1 that are in Col 2.
HTH
 
Thanks - It works perfekt after some modifications to my danish version of
Excel :-)

Thanks again.

After a test I did as follow:
=IF(COUNTIF(A$1:A$5;B1);"XXX";B1)
 
Back
Top