Oops...

Put this formula in C2 and copy it down the length of column B's entries

=IF(COUNTIF(A:A,B2)=0,"Unique","")

"orbojeff" wrote:

I have 2 Columns A & B
Column B contains all of the data in Column A and then some.
I need a function that will show all of the extra items in Column B.