Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
comparing 2 columns of numbers
what would be the best way to compare 2 columns of numbers?
the master list is downloaded every day. numbers may be added or deleted. i would need to find just the ones that were added or deleted in the master list. i wrote a routine that sorts and compares side by side numbers and if it finds one, it changes the offset to the next row and continues on to the next row. this seems to work fine for numbers that were added. i just wondered if there was a better way to filter them out. For Each cell In ws2.Range("A1:A" & lastrow3) cell.Value = cell.Value * 1 'in case any are stored as text cell.Offset(0, 1).Value = cell.Offset(0, 1).Value * 1 'in case any are stored as text If cell.Value < cell.Offset(0 - Cntr, 1).Value Then Debug.Print cell.Address Cntr = Cntr + 1 .Range("C" & Cntr) = cell.Value End If Next -- Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help comparing 2 columns of number to find unique numbers | Excel Worksheet Functions | |||
Comparing 3 numbers | Excel Discussion (Misc queries) | |||
Comparing two columns of numbers | Excel Worksheet Functions | |||
comparing numbers in a sheet | Excel Discussion (Misc queries) | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) |