I will explain Excel tip to you. It is to make serial number in duplicate data. You can use "countif" sentence. Please, see the attached file.

*I will explain an Excel tip to you.It is on how to make serial number in duplicate data.

You can use countif sentence.Please see the attachment file.