•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to find missing data
Spreadsheet 1 is a list of employees, their job l, and their current certifications.
Spreadsheet 2 is a list of all jobs and what certification is required on that job.
I need to find what certifications the employee is missing based on the requirements of their job. I can’t think of a way to look up since it’s many to many. So far I’ve added a helper column of Job/Cert to both spreadsheets but not sure where to do from there.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#cloud-based spreadsheet applications
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#big data management in spreadsheets
#rows.com
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#AI-native spreadsheets
#Excel compatibility
#financial modeling with spreadsheets
#predictive analytics in spreadsheets
#cloud-native spreadsheets