How do I identify duplicate rows?

How can I identify duplicate rows in a column by adding an additional column to identify the duplicate. numbering the dupes 1,2,3 etc.


Sample data:

Row PK#

Engg.FY23O&M012

Engg.FY23O&M012

Engg.FY23CIP012

Engg.FY21CIP001

Engg.FY23O&M012

Engg.FY23CIP012

Engg.FY21CIP001

Best Answer

Answers