I have an Excel with data (attached file). row(0) - position code, row(2) - status.
The condition is that If the position code in the template occurs 1 time, then in the “status” field should be “Yes”.
If the position code in the template occurs 2 or more times, then in the “status” field the value “Yes” can be specified only once.
If this condition is not met, then opposite the code in which the condition is not met, add a comment in the field “status” with value “comment”
I’ve tried a lot of ways of solving this task such as for each row in DT1 (attached Excel) filter by “position code” and status “Yes” getting DT2, but then I don’t know how to add comment for each row in DT2 except one.
Please, help me to solve this task.
Thanks in advance
Example.xlsx (8.2 KB)