Start Serial Number from Empty Cell and 2nd duplicate as 1 and 3rd duplicate as 2

[Noman050]

Hi all,

Please check the excel sheet to know the result i wanted in excel

Actually need the first duplicated entry as same value of the Column A and 2nd duplicated entry as Apple - 1

[JohnTopley]

Try

=IF(COUNTIF($A$1:A1,A1)=1,A1,A1& "-" & COUNTIF($A$1:A1,A1)-1)

[Noman050]

Thanks it worked

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Phuocam]

Or try:

=A1&TEXT(COUNTIF($A$1:A1,A1)-1,"\-0;;")

[FlameRetired]

@ Phuocam

Very clever.