find duplicate and update ID number

I have 1000 of rows data in excel and wanted to find the duplicate of the names in all column. if found any same name then it should capture the ID number(from Column A) . So kindly help me in this.

ID P1 P2 P3 P4 P5 if find any name duplicates then capture ID from column A
ID1 Harish Mahesh Ganga Karthik Prashant ID1, ID2
ID2 Jyoti Deepak Jagadish harish Prashanti
ID3 Monika Mahesh Suresh Karthik Deepak ID4
ID4 Swati Deepika Namo JK Monika
ID5 Suresh Dhyan Suresh Mahesh Ganga ID3, ID5
Top Contributor Asked 44 mins ago in VBA.
Add Comment
0 Answer(s)
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.