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