Put this in C1
=isnumber(match(b1,a:a,0))
then drag down

Then filter to show only the Falses.



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.

--

Dave Peterson