This is a method that can be used when you want to know the last row where data is entered.
A simple way is the COUNTA function
A simple way is to use the COUNTA function.
COUNTA – Google Docs Editors HelpReturns the number of values in the dataset. Usage example COUNTA(A2:A100,B2:B100,4,26) COUNTA(1,2,3,4,5,C6:C20) Syntax COUNTA(value1, ) value1 – count the number
support.google.com
Returns the number of values in the COUNTA
dataset.
COUNTA(value1, [value2, …])
Put =counta() and put the range inside.
At this time, the point is not to enter the cell number at the end of the range (enter only the alphabet of the column) .
Then the spreadsheet will automatically recognize the last row .
So if the number of rows increases and the data increases.
The value of the part containing the function also changes dynamically.
Add the upper line (+2 in this case)
After that, if you are counting from the 3rd line, add 2.
It’s okay to count from A1, but in case the A1 cell is a blank cell, for example, the cells are shifted and added.
Now we have the last line number!
summary
You have now dynamically retrieved the last row of a column that has data.
What if there are blank lines? There is a problem, so I would like to try it in another article about that point.
Please refer to it