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
Plz try:
=ArrayFormula(iferror(match(B2:B,unique(B2:B),0)))