Hi All,
I want to catch errors for the following scenarios:
If same name assigned with different codes or same code assigned with different name, are considered as errors.
Code Name
1 xyz
2 mns
3 xyz
2 pqr
4 abc
5 uio
In the above data, row 1 and row 3 should be error , same for row and row4, row 5 and row 6 are ok
Looking for a formula based approach.
Regards,
Kaushik
I want to catch errors for the following scenarios:
If same name assigned with different codes or same code assigned with different name, are considered as errors.
Code Name
1 xyz
2 mns
3 xyz
2 pqr
4 abc
5 uio
In the above data, row 1 and row 3 should be error , same for row and row4, row 5 and row 6 are ok
Looking for a formula based approach.
Regards,
Kaushik