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:


Here is an ScreenShot:

enter image description here

Best Answer