look to see if a number exists in another column

[inosent]

hi

i have one column with 15000 numbers

i have another column with 18000 numbers

there are, by simple math, 3000 numbers missing, but i dont know which ones

i tried using

=IF(ISNUMBER(MATCH(E2,D1:D20000,0)),"",1)

but it finds a total of 1784 missing. so obviously that function isnt working

any way to do this to get an accurate fix on what is and isnt in that column?

thanks

 

[mikerickson]

You could put Conditional formatting on your column of 18000 with a formula
=ISNA(MATCH(E2,D:D,0))
assuming E is the 18000 column and D is the 5000 column.

P.S. might making $D$1:$D$20000 an absolute reference make your formula work properly?

 

[inosent]

perfect, that worked. thank you!