In this example I am trying to make a serial numbering without counting blanks.
I have tried to use ISBLANK, SEQUENCE and MATCH.
ISBLANK
SEQUENCE
MATCH
Is this possible?
try:
=ARRAYFORMULA(IF(E2:E<>""; COUNTIFS(E2:E<>""; E2:E<>""; ROW(E2:E); "<="&ROW(E2:E)); ))