1 min readfrom 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.

submitted by /u/Lundorff
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article