Duplicate row comments in excel using linq

Help
1

I have an excel with Employee ID, Project ID, budget and department ID…

If there is one duplicate row, then write a comment as “repeated” in a new column “comment”

If there are 2 duplicate rows, then write a comment as “repeated” in a new column “second comment”

Please help me out with this

Thanks in advance :blush:

2

@Joywin.Madtha

How many new columns we have to add
If some rows are duplicated twice and some rows are duplicated thrice should we add new columns comment and Second Comment Seperately.

Regards,
Mahesh

3

@Joywin.Madtha

Use Write cell activity and write the Excel formula in range.
=COUNTIF($A$2:$A2,A2)

This will help you.

Thanks,
Suresh J

4

For 1 duplicate row one column
If 2 or more duplicate rows add new column with comment “repeated”