Data Compare

  • Thread starter Thread starter Mike Cook
  • Start date Start date
M

Mike Cook

Hi , Can you help :-

I have 2 columns of numbers, what I want to do is separate the number that
appear in both columns from the numbers that don't. the numbers that dont
appear in both columns should be copied to column c

Preferably not using vb

Example

Column A Column B Column C

A1 A1
A2 A2
A3 A3
A4 A4
A5 A5
A6 A6
A7 A7
A8 A8
A9 A9
A10 A10
A11 A11
A12 A12
A13 A13
A14 A14
A15 A15
A16 A16
A17 A17
A18 A18
A19 A19
A20 A20
 
Not EXACTLY what you requested (2 columns of results):

Assuming rour data columns are A1:A23 and B1:B23,

In C1, enter
=IF(COUNTIF($B$1:$B$23,A1)=0,A1,"")

in D1, enter:
=IF(COUNTIF($A$1:$A$23,B1)=0,B1,"")

and copy down to C:23:D23

HTH
 
Back
Top