Hello,

I need urgent help for the following cases : -

Staff No. Action/Reason Deptcode
A1 0001 Pay chg 1234
A2 0001 Pay chg 1234
A3 0001 supr Chg 1234
A4 0001 Job chg 1239
A5 0005 Incentive chg 3456
A6 0005 Dept Chg 9888
A7 0005 Dept Chg 7865

1) Staff No.0001 has duplicate of Pay chg column
2) Both staffs have deptcode change row A4 for staff 0001 and row A6 & A7
for 0005

Please advice how to identify these. I have total of 6000+ rows to sort it
out.

Thanks in advanced