Finding Duplicate rows in Excel and Updating Status column as Duplicate
I have a scenario to find the duplicate values , and update the status cloumn as Duplicate
I have Excel with 20 columns , Acc No , To date , From Date columns are there if incase theese three values maches with any row of the three values then i need to update the Status column as Duplicate .
I am able to get those three values and compared it successfully but unable to set the Status column .
Can anybody help on this.
i have attached my automation below.
***Updated by moderator: Lochan to add Categories***