Add comment based on duplicate rows

I have an excel sheet with employee ID, department ID, project code and budget

If there’s 1 duplicate row I have to comment as " repeated" in a column named “first update”

If there’s 2 duplicate rows, I have to comment as “repeated” in a column named “second update”

The output should be stored in a new excel sheet

@Joywin.Madtha

Using write cell activity use can write an Excel Formula and achieve this .

=COUNTIF($A$2:$A2,A2)

Thanks,
Suresh J

@Joywin.Madtha

Can you please post the screenshot of the Excel sheet with Output as you are expecting. So that it will help us for understanding better.

Regards,
Mahesh

Screenshot_20190927-161902

Input excel sheet

Screenshot_20190927-162041

Output excel sheet

If one duplicate row then add comment in column “project comment”,

if more than one duplicate row then add comment in column “second project comment”

Thanks in advance @MAHESH1