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

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#discrepancies
#Workday
#Excel
#supervisor
#manager
#formulas
#location
#IF
#COUNTIF
#flagging
#records
#instance
#incorrectly
#column M