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:
Post a Comment