Rhino try this:
In C2 enter formula:
=IF(B2="","",IF(ISNUMBER(MATCH(B2,A:A,0)),"",ROW() ))
In D2 enter formula:
=IF(ROWS($1:1)COUNT(C:C),"",INDEX(B:B,SMALL(C:C,R OWS($1:1))))
In E2 enter formula:
=IF(D2="","",IF(AND(COUNTIF(A:A,D2),COUNTIF(B:B,D2 )),"In A &
B",IF(AND(COUNTIF(A:A,D2),NOT(COUNTIF(B:B,D2))),"I n A not
B",IF(AND(NOT(COUNTIF(A:A,D2)),COUNTIF(B:B,D2)),"I n B not A","Not in A nor
B"))))
Copy or drag the three formulae down to the bottom of your data. Hide column C
You are now left with column D containing your unique list of numbers and
column E will tell you which column the unique number appears.
Hope this helps



"Rhino" wrote:

Hi guys, I have a big worksheet with a ton of columns, what I need to do is
find all the numbers from column B that are in column A and create a list of
cells from column B that are unique and not in column A. The sheet looks
like this but goes on for 5K rows. If you look at the 2 columns the first
number in column B (11971268365) is also in column A and I don't want that
number. I do want the 2nd and 3rd number (etc). Can you guys help me do
this? I can't seem to figure it out on my own. Please feel free to e-mail
me as well

Thanks guys

A B
CU83201 AcctNum
6100038 11971268365
2545179031 13519408214
11971268365 14120788327