Hi all, I have 2 similar sets of data on a same spreadsheet, one of which has less records than the other. The reference ID of the records are unique, some can be foudn on both sets of data, some only on either one set. Can I write a macro to do a line by line comparison of the ID and thereby their value?
Eg
1st set 2nd Set
1 20 1 22
2 50 2 59
4 70 3 60
5 100 4 75
For instance, I will want to match their ID by line, ie, I have to insert a line above ID 4 to push ID 4 record down to match them on line basis. And when that is achieve, have another column calculate the difference between the values by their IDs. Eg, the value diff of ID 4 is 5.
I'm really baffled by this, any help will be great!
Thanks a lot
Eg
1st set 2nd Set
1 20 1 22
2 50 2 59
4 70 3 60
5 100 4 75
For instance, I will want to match their ID by line, ie, I have to insert a line above ID 4 to push ID 4 record down to match them on line basis. And when that is achieve, have another column calculate the difference between the values by their IDs. Eg, the value diff of ID 4 is 5.
I'm really baffled by this, any help will be great!
Thanks a lot