Separating Different and Identical Records with Cell Comparison
File teaching Separating Different and Identical Records with Cell Comparison operation.
Excel Source: Separating Different and Identical Records with Cell Comparison
It is possible to identify common and different values between the two lists. Care was taken to make the comparison both on a row and cell basis. Visual cues have been added for easy identification of different records. It is intended that the study can be used in data integrity checks.
Hope it is useful.