Answer the question
In order to leave comments, you need to log in
How to get the last number from a column/row in Google Docs?
Dear colleagues!
I have a question that I can't seem to find an answer to in the official Google guide.
There is a column with numbers. These numbers are added every day, by adding below, in the same column.
In another tab, I am making a formula. I need the formula to take the last number from the column that is updated every day in the next tab.
How can this be done?
Thanks for the replies!
Answer the question
In order to leave comments, you need to log in
In the column adjacent to the "numbers" write a formula that determines the row number =ROW (). Checking if a cell is full won't hurt =IF(...).
Define the maximum number in the table with row numbers =MAX(...).
LOOKUP'om take number from a "numerical" column from a line with the maximum number.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question