Finding the missing numbers

[debra]

Each month I get a list of whole numbers, from 1 to around 5000, in a mostly random order. Each month some of those numbers (around ten to twenty of them) are no longer there and new numbers are tacked on. I need a way of finding out what numbers that were on the October list are not on the November list. I don't care about the new numbers added. What is the trick? Thanks in advance.

[VBA Noob]

Can you give more details

Does the Oct data get deleted. Does the new data overwrite all the old data or just some cells

VBA Noob

[duane]

with the October #'s ina spreadsheet ypu could use MATCH or VLOOKUP to id the ones included (or excluded) from the November #'s

[debra]

I have access to the new numbers early in each new month. I can copy and paste the numbers onto a excel spreadsheet column and my thoughts were to just paste the new months numbers (1 to around 5000 with a few missing ones) in a column next to the previous months numbers and have a macro find which numbers on the old month are not on the new month.

When the next month comes, I would do the same. Nothing fancy. Only trying to find the numbers missing on the new month that were on the old month.

A neighbor built a macro and it really started off well but started bogging down around 1000 and basicly gummed up by 4000. I appreciate the help.

[duane]

if one set is in a1:a500, and the other set is in b1:b500, just put
=match(b1,$a$1:$a$500,0) in c1 and copy down to c5000.

You will get a N/A for a numbers in column b not found in column a

[duane]

oops - those 500's should be 5000's