1 min readfrom 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?

submitted by /u/N0t_my_prob1em
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article