Try...

C1, copied down:

=INDEX($B$1:$B$100,SMALL(IF(COUNTIF($A$1:$A$50,$B$ 1:$B$100)=0,ROW($B$1:$B
$100)-ROW($B$1)+1),ROWS($C$1:C1)))

To include an error trap, try...

=IF(ROWS($C$1:C1)<=SUM(--(COUNTIF($A$1:$A$50,$B$1:$B$100)=0)),INDEX($B$1:
$B$100,SMALL(IF(COUNTIF($A$1:$A$50,$B$1:$B$100)=0, ROW($B$1:$B$100)-ROW($B
$1)+1),ROWS($C$1:C1))),"")

Both formulas need to be confirmed with CONTROL+SHIFT+ENTER, not just
ENTER. Adjust the ranges accordingly.

Hope this helps!

In article . com,
"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.