Data Compare

[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

 

[Ardus Petus]

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:2323

HTH