I would like to use match to find the index of the first empty cell in a row.
I have tried the first arguments “” and “^$” but it will only give N/A. It works with other values and regular expressions for non-empty cells, just not empty.
I suppose alternative approach would be finding the last not empty cell’s column and adding one. Regular expressions are enabled.
=MATCH(1;ISBLANK( <the row> );0)