I want to have an Arrayformula at A1 to produce this output:

I want to have a same serial number for same names, names would not be sorted & could repeat any number of time.

Google Sheet Link

CodePudding user response：

Plz try:

=ArrayFormula(iferror(match(B2:B,unique(B2:B),0)))