Notifications
Clear all
Topic starter
Hi,
Please can you help me to flag the repeated raw as below.
I have file contain two column “First Name” & “Second Name” and sometimes the names write as below.
First Name | Second Name |
Alex | Jem |
Jem | Alex |
So I want give flag for each raw as below.
First Name | Second Name | Flag |
Alex | Jem | A |
Jem | Alex | B |
Please check attached file to get other sample.
Thanks;
Bill
Posted : 22/07/2019 12:44 pm
Hi Bill
See if this helps.
It should be able to handle A-Z (if you have that many )
Good luck.
Sunny
Posted : 23/07/2019 2:38 am
Topic starter
It works perfectly, Thank you very much!
Thanks;
Bill
Posted : 23/07/2019 4:59 am