•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is it possible to compare 2 data lists and find the IDs with different amounts? Better explanation inside...
This: https://i.imgur.com/mL4U8wD.jpeg
Column A and B is the first data list. It means ID 101 contains 10 items and 102 contains 10 items etc.
Column C and D is the second data list and with the same setup as the first, but the amounts might differ and the IDs might not match the first data list.
Is there a way to compare the amounts of the 2 lists, and create a list of IDs that has a different amount? ID 101 has 10 items in the first data list, but only 9 in the second, so ID 101 goes on the list and so on.
[link] [comments]
Want to read more?
Check out the full article on the original site