Forum Discussion
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 - ...
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.
Thank you so much sir. It helps me lot😊
