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

Hi everyone,

Please Look into the example

A B
Kiwi

Kiwi 1

Kiwi 2

Apple

Kiwi 3

Apple 1

Please look into the excel sheet for the better understanding

Hi, Noman050!

You could try:
[B2] : =IFERROR(1/(1/(COUNTIF(A$2:A2,A2)-1)),"")

Blessings!

Thanks it worked

Try this:

B2 =IFERROR(1/(1/(COUNTIF(A$2:A2,A2)-1)),"")

Edit: John beat me to it.