Hi all,
I have not been around for a while as I have been busy in work, but I have a question if it could be answered. I often have to compare two sets of numbers. They are just list of pay numbers, and very often one will not appear on the other. I want to make a list out of the ones that do not appear on one list. Does that make sense?
At the moment, I put the two list side by side, the manually delete the ones that appear on both lists and the data filter the one that I have deleted from and choose 'non blanks'. Both list are of differing lengths of that helps, although I could make them the same by adding 'zeros'.
There must be a easier way, and I have tried a couple of formulas, but without success.
I had forgotten about the code maker, and have added the trial page below
I have not been around for a while as I have been busy in work, but I have a question if it could be answered. I often have to compare two sets of numbers. They are just list of pay numbers, and very often one will not appear on the other. I want to make a list out of the ones that do not appear on one list. Does that make sense?
At the moment, I put the two list side by side, the manually delete the ones that appear on both lists and the data filter the one that I have deleted from and choose 'non blanks'. Both list are of differing lengths of that helps, although I could make them the same by adding 'zeros'.
There must be a easier way, and I have tried a couple of formulas, but without success.
I had forgotten about the code maker, and have added the trial page below
Pay number test.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 75 | 75 | ||||
2 | 94 | 123 | ||||
3 | 123 | 465 | ||||
4 | 222 | 555 | ||||
5 | 225 | 871 | ||||
6 | 465 | |||||
7 | 468 | |||||
8 | 555 | |||||
9 | 735 | |||||
10 | 871 | |||||
Sheet1 |