Forum Discussion
Excel
Feb 13, 2021Iron Contributor
Question related to finding duplicates
Hello Everyone, How to find the duplicate values When the data of First column with First Name ,Middle Name, Last Name and the other column with Last Name, Middle Name, First Name Like - ...
Feb 13, 2021
Please mention attached file and picture to this message box.
Split the second table into columns based upon delimetr and then using Textjoin function concatenate them.
Copy newly formed column values to the first table (column).
From Data menu, select Remove Duplciates.
I think this can help you.
If you find this solution as a best one, please mention.
- ExcelFeb 13, 2021Iron Contributor
Thank you so much sir. It helps me lot😊