Comparing columns to eliminate same data

[mnatanzon]

I need to compare 2 columns in excel with numerical data to remove all doubles

Is there a formula to do that? My columns have about 60,000 lines each

Thank you

[JBeaucaire]

Can you elaborate further?

Compare column A to column B. All items in column A that are also in column B are:
1) deleted in both columns
2) deleted in column A
3) deleted in column B

[mnatanzon]

Oh sorry...
I have column A with about 15,000 lines of numerical digits in it (6 digits per cell)
I have column B with about 60,000 lines of numerical digits in it (6 digits per cell)

99% of numbers in Column A appear in Column B. I need to see which of Column A dont appera in Column B (that 1%)

Ultimately, I just want to see the numbers that are in A (shorter column) that are not in B.

Hope this clarifies it a bit

[JBeaucaire]

See them where? I gave you a list of options to choose from. Select one or specifically stipulate what you want to happen...exactly what and where.

Is there titles in row1 and the data starts at row2? Can you add titles if they're missing? The AutoFilter may be the ticket here.

[JBeaucaire]

1) Insert a row at the top and put titles above your columns
2) Highlight column A and select Insert > Column
3) In A1 put "Key"
4) In A2 put this formula:

=ISNUMBER(MATCH(B2,C:C,0))

5) Select cell A1
6) Select Data > Filter > Autofilter
7) Filter column A by the value FALSE

You're now looking at all the values in column B that are NOT in column C. Copy the values elsewhere if you wish, then turn off the Autofilter and/or delete the column A you added.

[mnatanzon]

Thank you sooooooooooooo much!!!!!
I'm sorry if I was unclear. I've never done something like this before and only know the simple formulas.

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].