I have a spreadsheet where cells have a comma delimited collection of numbers that I need to compare:
For example:
The value of A1 = "14, 16, 25, 22, 430, 500"
The value of B1 = "14, 16, 38, 22, 430"
I would like the value of C1 to be, in the same comma delimited format, all the numbers A1 has that B1 does NOT.
I would like the value of D1 to be, in the same comma delimited format, all the numbers B1 has that A1 does NOT.
So based on the example above:
C1 would = "25, 500"
D1 would = "38"
I assume this is too complex to do with a formula, so how would I do this with VBA?
This would need to be repeated for hundreds of lines and ran automatically.
Bookmarks