Excel 2007 : Duplicate names avoided

[sushil10s]

Hi

I have a list of names in col A and in col B. I need formula so that if a name from col A is there in col B, that name should not appear in col C.

Thanks

[jraj1106]

Hi
Try this:
=IF(A1<>B1,A1,"")

Regards..

[NBVC]

Try:

=IF(ISNUMBER(MATCH(A2,B:B,0)),"",A2)

copied down.

[royUK]

You could use COUNTIF to check if the name in say A1 is there

In C1 & copied down, note adjust range reference for checking

=IF(COUNTIF($B$1:$B$20,A1)>=1,"",A1)