•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What's the best way to sort out differences between data sets?
I have a large data set of an inventory with around 10,000 individual serial numbers that I'm currently auditing. We are continuously pulling from this inventory during the audit and my inventory will be a tad different next week compared to what it was when I exported the data this week.
What's the best way to sort out the differences between the sheet I pulled this week and the one I pull next week? I know how to filter out duplicates, but I'm wanting the new sheet to be able to say "x from old sheet isnt in new sheet" and not list it if that makes sense
[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
#rows.com
#Excel compatibility
#large dataset processing
#financial modeling with spreadsheets
#data set
#inventory
#serial numbers
#audit
#differences
#filter
#duplicates
#sheet
#exported data
#new sheet