I need to find the number of row of the next empty cell in a column.
For example in Column A I have
I like to create a formula that can take in the column index and return a row number. In this case Column index:A, Answer Row = 4. I did it using VBA, but I can't seem to do it using a formula. The reason for this is that if a user use my spreadsheet and add a row in column A I need to update the next empty cell row number 5 as soon as the user type in anything in Cell A4.
Any help is greatly appreceiated.