Solved: Compare Column Data

[lienlee]

=IF(ISERROR(MATCH(A2,$C$1:$C$597,0)),"",A2)

This is the function im using to compare 2 columns.
What it does is that
It compares column A to C
and in Column B it shows the field that exists within column C

How can I do the opposite?
I want to list all the unmatched data between the column

[austenr]

Try this in column B
[vba]=IF(ISERROR(MATCH(A2,$C$1:$C$597,0)),A2,"")
[/vba]

[lienlee]

Try this in column B
[vba]=IF(ISERROR(MATCH(A2,$C$1:$C$597,0)),A2,"")
[/vba]

Thanks.

edit. i just checked again. it doesnt seem to get it all.

[lienlee]

edit. i just checked again. it doesnt seem to get it all.
it checks if the word is there. and not the exact word

for example

in column A - text

in column C - text34

Itll show that 'text' does exist..which it doesn