I have a very unique request. Have 4 columns A, B, C D namely D0_ID, LastName, FirstName, Responsibility.
and some 1300 rows. MY requirement is to find the duplicates in Column A i.e D0_ID and copy the corresponding column D i.e responsibility in Column E i.e Duplicate responsibilities
same row as duplicate found. For example D000119 is duplicate of first row... so i need the responsibility of Row1 and Duplicated Row 2 printed in Row2,E column. Can we achieve this requirement by any chance? Please help me.
D0_ID LastName FirstName Responsibility Duplicate responsibilities
D000119 Lotito Maryann HCSG CSR II
D000119 Lotito Maryann HCSG Claims HCSG CSR II,HCSG Claims
D001810 Popa Arlene HCSG CSR II
D001810 Popa Arlene HCSG Claims HCSG CSR II,HCSG Claims,HCSG Genworth,HCSG MetLife
D001810 Popa Arlene HCSG Genworth HCSG CSR II,HCSG Claims,HCSG Genworth,HCSG MetLife
D001810 Popa Arlene HCSG MetLife HCSG CSR II,HCSG Claims,HCSG Genworth,HCSG MetLife
D002913 Brown Dorothea HCSG CSR II
D002913 Brown Dorothea HCSG Claims
D002913 Brown Dorothea HCSG Employer Accounts
D002913 Brown Dorothea HCSG MetLife
D002913 Brown Dorothea HCSG NPOP
D003929 Lawton-Jenkins Marilyn HCSG CSR II
D003929 Lawton-Jenkins Marilyn HCSG Claims
D004048 Hom Betty HCSG CSR II
D004048 Hom Betty HCSG Claims
D004048 Hom Betty HCSG Employer Accounts
D004048 Hom Betty HCSG NPOP
D004144 Smith Joseph HCSG CSR II
D004144 Smith Joseph HCSG Claims
D004144 Smith Joseph HCSG NPOP
D009655 Smallwood Crystal HCSG CSR II
D009655 Smallwood Crystal HCSG Claims
D009793 Simo Arlene HCSG CSR II
D009793 Simo Arlene HCSG Claims
D009793 Simo Arlene HCSG NPOP
D009830 Williams Barbara HCSG CSR II
D009830 Williams Barbara HCSG Claims
D009830 Williams Barbara HCSG NPOP
Thank you very much,
Sree
Bookmarks