PDA

View Full Version : Solved: Compare Column Data



lienlee
08-03-2010, 06:18 AM
=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
08-03-2010, 06:25 AM
Try this in column B
=IF(ISERROR(MATCH(A2,$C$1:$C$597,0)),A2,"")

lienlee
08-03-2010, 06:53 AM
Try this in column B
=IF(ISERROR(MATCH(A2,$C$1:$C$597,0)),A2,"")

Thanks.

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

lienlee
08-03-2010, 07:16 AM
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