|
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|
|
Comparing two columns and listing differences
Hi
as a starting point:
http://www.cpearson.com/excel/duplic...tractingCommon
http://www.cpearson.com/excel/duplic...#InOneNotOther
--
Regards
Frank Kabel
Frankfurt, Germany
gb wrote:
Hi
In summary, I have two columns (May and April) where the data in each
cell is a string of numbers, mostly all 10-digits long.
The aim was to compare data now (May) to the data from a month ago
(April), in order to work out what data is being queried now that
wasn't being queried one month ago. I hope that makes sense.
Whilst it could be possible to sift through the list and work out
what
numbers are new, it would obviously be easier to have a piece of code
that would do it for me. The data I refer to above has been sorted
out from a wider batch of data and refined even further by other code
that I use, so it would make sense to complete the whole thing by
means of code.
Anyway, could anyone assist in providing the code that would
determine what numbers exist in the May column that do not exist in
the April column and either:
(a) highlight the new numbers in the May column, or;
(b) copy the new numbers to another column or worksheet/book?
Thank you very much for any help you're able to provide
Thanks
gb
|