Find numbers that dont exists in both columns

[peter233]

Hi!

I have two large columns with different numbers, example:

Column A Column B
100121 100121
102131 102131
251154 251154
565612 565612
656512 656512
566564 566564
121211
565444

I want to create a macro or function that compare these 2 columns and returns the numbers that dont exists in both columns.

In the example above the function/macro would return: 121211
565444
Help is very appreciated!

[sweep]

Paste this

=IF(ISERROR(MATCH(B1,A:A,0)),"Not in both columns","In both columns")

into cell C1 and copy down

hth

Dave

[peter233]

Works perfect, thank you very much