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

2

Try

=ARRAYFORMULA(IFERROR(MATCH(A2:A12&ROW(A2:A12),FILTER(A2:A12&ROW(A2:A12),A2:A12<>""),0)))
  • 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 Mar 12 '18 at 22:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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