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:
Here is an ScreenShot: