Consecutive numbering skiping empty cells with ArrayFormula

Question

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:

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:

TheMaster · Accepted Answer · 2018-03-12 16:43:44Z

2

Try

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

answered Mar 12, 2018 at 16:43

TheMaster

3,36514 silver badges32 bronze badges

Thanks a lot!!! it worked like a charm. I don't understand very good the formula, but it do the job! thank you!
– Abiel Muren
Commented Mar 12, 2018 at 22:41

Add a comment |

1 Answer 1