Google-sheets – Consecutive numbering skiping empty cells with ArrayFormula

formulasgoogle sheetsgoogle-sheets-arrayformula

I am trying to auto-number only the existing names on a cell using an arrayformula:

I have two cells one for the names and the other for consecutive numbers.

Here I have an example of what I want to achieve:

Link to My Google Sheets Document

The current formula still counting the empty spaces, but it only should count the ones with content:

=ARRAYFORMULA(if(ISBLANK(A2:A12),"",row(Z1:Z12)))

Here is an ScreenShot:

enter image description here

Best Answer

Try

=ARRAYFORMULA(IFERROR(MATCH(A2:A12&ROW(A2:A12),FILTER(A2:A12&ROW(A2:A12),A2:A12<>""),0)))