Sharing some useful tips, solutions and notes for Geeks.

Tuesday, January 5, 2021

Adding suffix to duplicate rows for making it unique in excel - formula

Assuming the excel got header and the duplicate rows are in first column:

=IF(COUNTIF(A$1:A1,A2)>0,A2 & "." & COUNTIF(A$1:A1,A2),A2)

No comments: