Comparing two columns and listing differences

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: gb (gb_at_gbgbgb.gb)
Date: 05/19/04 

Date: Wed, 19 May 2004 18:20:06 +0000 (UTC)

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

Relevant Pages

  • Comparing two columns and listing differences
    ... I have two columns where the data in each cell ... is a string of numbers, ... The aim was to compare data now to the data from a month ago, ... wider batch of data and refined even further by other code that I use, ...
    (microsoft.public.excel.worksheet.functions)
  • Comparing two columns and listing differences
    ... I have two columns where the data in each cell ... is a string of numbers, ... The aim was to compare data now to the data from a month ago, ... wider batch of data and refined even further by other code that I use, ...
    (microsoft.public.excel.misc)
  • VB, implementing the high score within this code
    ... Private possibleAs String ... Private Function SolvePuzzleAs Boolean ... ' Calculates the possible values for all the cell ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Formulas containing hard coded values
    ... Dim R As Range, sdoit As String ... MsgBox "Cell contains hard codes" ... Dim Fml As String, LCtext As String ... For Each Rng In R.Precedents.Areas ...
    (microsoft.public.excel.programming)
  • Re: Marking points read for coordinates
    ... In "Private Sub GetCoordinates()" comment all the code between ... (ByVal lpClassName As String, ByVal lpWindowName As String) ... ' cell A1 which is the base for all object coordinates on a sheet. ... Dim chtObj As ChartObject ...
    (microsoft.public.excel.programming)