Unique values

[Throughstream]

Hi I have two columns with names in both columns. Column A has all the names in it and Column b only has some of the names in it. I would like a formulae that looks at both columns and in column C only displays the names that don't appear in column b but do appear in column A. the names will be in random orders

Thanks in advance

[mrice]

Try pasting

=IF(COUNTIF(B:B,A1) = 0,A1,"")

into C1 and copying down.

[Throughstream]

Try pasting

=IF(COUNTIF(B:B,A1) = 0,A1,"")

into C1 and copying down.

Thanks great thank you