Hi,
I have two data sets: System Data and Manual Input - both of them consist of Employee ID and Code, where code may differ in Manual Input when compared with System Data.
I would need a formula, that will display the results: 'OK' for same code and 'Changed' for changed codes for a particular employee ID. (example attached)
Thank you in advance for your help.
Bookmarks