•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
Tagged with
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives
#data lists
#IDs
#compare
#amounts
#items