I have an excel file that is exported from the source system on a recurring basis where I do manual validation across cells (sample file attached) and it is very tedious and time consuming so I was wondering if there is a way to build in the logic I use for my validation into Excel, whether it’s a formula or Data Validation or Power Query…..anything that can help automate this validation. Thank you in advanced! Help would be much appreciated!
Associations tab outlines which the field and value associations. Ex. The Sales unit only has 2 division: Account Management and Executive)
Not Clean tab is the tab that has the raw data which the user has input in the source system. This data needs to be mapped against the "Associations" tab to identify the cells that do not align with the associations. Ex. Since the Sales unit only has 2 division: Account Management and Executive, it should identify Column C3 because "PR" is not a Sales unit.
Clean tab is the final result I have after manually making the changes
Bookmarks