•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Comparing 2 columns for Discrepancies
I am looking for assistance on a project I took on to find discrepancies from Workday. An export of Workday information is sent in Excel and I've created a few formulas to find instances of same supervisor and manager or cases where the location is not right.
I need help to create something that will show me when someone/any in the manager column is showing in any of the supervisor boxes incorrectly.
Attempted IF and COUNTIF but it's still not flagging the records needed. Any ideas on how I can get this set up?
Example: Column M, Supervisor has J Doe, D Jane and Y Roger. Column Q, manager has other names and D Jane who is a manager. How to get the system to flag D Jane for being in column M?
[link] [comments]
Want to read more?
Check out the full article on the original site