1

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

1 Answer 1

2

Try

=ARRAYFORMULA(IFERROR(MATCH(A2:A12&ROW(A2:A12),FILTER(A2:A12&ROW(A2:A12),A2:A12<>""),0)))
1
  • Thanks a lot!!! it worked like a charm. I don't understand very good the formula, but it do the job! thank you! Mar 12, 2018 at 22:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.