Forum

Notifications
Clear all

Employees List

3 Posts
2 Users
0 Reactions
123 Views
(@bill-jone)
Posts: 28
Eminent Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Bill

See if this helps.

It should be able to handle A-Z (if you have that many Laugh)

Good luck.

Sunny

 
Posted : 23/07/2019 2:38 am
(@bill-jone)
Posts: 28
Eminent Member
Topic starter
 

It works perfectly, Thank you very much!

Thanks;

Bill

 
Posted : 23/07/2019 4:59 am
Share: