how compare two columns

[robhare]

Gooday I'm try to find which names I,m missing from two columns . I write the formula like this =IF(ISERROR(MATCH(A2,$C$1:$C$179,0)),"",A2)
This matches the names but how can I write it so that the column shows names that are extra , eg do not match?
thanks
Rob

[sweep]

Hi,

How about just reversing the formula?

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

[robhare]

thanks works fine