CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaarray-formulas
Aashit Garodia
Aashit Garodia

Reputation: 410

ArrayFormula to give Fixed serial number to same name

I want to have an Arrayformula at A1 to produce this output:
enter image description here
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

Upvotes: 0

Views: 150

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34265

Plz try:

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

Upvotes: 2

Related Questions