Question

4
Replies
246
Views
Amar_nadh Member since 2016 8 posts
Accenture
Posted: 2 years ago
Last activity: 2 years 9 months ago
Closed
Solved

How To Find Dulpicate Row in Excel And Update A column with Status As its Duplicate

Hi Team,

An excel having clolumns bank account number , From Date , To Date and Status

if there is any duplicate vallues occured like Three columns bank account number , From Date , To Date Are Same ( See Below Example) then we need to update the status column as Duplicate , If two columns are same and and Third columns is different then its not a duplicate value if and only if the three columns are same then only we need to update the status.

Bank Account Number From Date To Date Status

123456789 22-08-2006 01-10-2007

123456789 03-07-2010 05-09-2010

123456789 22-08-2006 01-10-2007 Duplicate

123456789 22-08-2006 01-11-2007

423823157 30-09-2015 09-09-2017

123456789 22-08-2006 01-10-2007 Duplicate

423823157 30-09-2015 09-09-2017 Duplicate

423823157 30-09-2016 08-09-2017

Thanks In advance

Amarnadh

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn