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
sureshj
(suresh_hserus)
2
@Joywin.Madtha
Using write cell activity use can write an Excel Formula and achieve this .
=COUNTIF($A$2:$A2,A2)
Thanks,
Suresh J
MAHESH1
(MAHESHKUMAR JV)
3
@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
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