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.

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

"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.

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.

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.

Hi,

You can use the following array formula (Ctrl+Shift+Enter)

=if(or(exact(A3,$B$3:$B$80)),"",A3)

Regards,

Ashish Mathur

"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.