Excel question

[Grisu]

I've become a bit rusty with Excel myself and now I seem to have a problem

I have two columns of 6-digit number (around 13000 each). I need to find out which numbers are in the first column but not the second. I've been trying to think up a way but didn't come up with anything...At the moment I'm rather close to just giving it up and write a short Java-App that does that for me

Any Ideas?

 

[Mise]

Assuming a header row, so numbers start from row 2, and the columns are A and B:
=match(A2,B:B,0)
then copy this down a third column.

If the number in cell A2 (and for each row thereafter) is not found in column B, it will return #N/A (if it is found, it returns the row number in column B at which it is found). Then you just autofilter on #N/A and copy the results out.

If my explanation is as rubbish as I think it is, just look up the MATCH function in help

 

[Grisu]

you're my hero that's exactly what I've been looking for

your explanation made perfect sense at least it would have if MS had the basic sense to not translate function name. Of course, the function MATCH doesn't exist in my version of Excel, but a quick google showed me that the german equivalent of it would be VERGLEICH.