Hello folks,
I am not an expert at excel, so not sure how to resolve this issue.
I have two excel worksheets:
File 1: Subset: This file has a subset of employees with various details including training status such as in-progress, completed, etc.
File 2: Full-Pop: This file has a complete list of employees with the same set of information. However, the training status in this file is more updated, so for example, an employee with a training status in-progress in the 'Subset' file may have a training status of 'completed' in the 'Full-Pop'. Additionally, the Full-Pop file also has newly hired employees.
I would like to be able to compare the two files and highlight differences in Purple. Differences must include any new employees and updated values such as status or dates on Full-Pop file.
I have looked at some of the forums online, but they seem to work only for row by row comparison.
Any help would be appreciated.
Thanks,
Pal Po.
I am not an expert at excel, so not sure how to resolve this issue.
I have two excel worksheets:
File 1: Subset: This file has a subset of employees with various details including training status such as in-progress, completed, etc.
File 2: Full-Pop: This file has a complete list of employees with the same set of information. However, the training status in this file is more updated, so for example, an employee with a training status in-progress in the 'Subset' file may have a training status of 'completed' in the 'Full-Pop'. Additionally, the Full-Pop file also has newly hired employees.
I would like to be able to compare the two files and highlight differences in Purple. Differences must include any new employees and updated values such as status or dates on Full-Pop file.
I have looked at some of the forums online, but they seem to work only for row by row comparison.
Any help would be appreciated.
Thanks,
Pal Po.
