How Do I Find the Last Number In a Column?

Comments: 3 Responses to “How Do I Find the Last Number In a Column?”

Gary Rosenzweig

5 years ago

Is the situation where there are blank cells at the bottom of a column? If not, then you can use ROWS() to get the number of ROWS and then INDEX to get the value of that cell.

But if you want to handle blank cells it gets complicated.

Peter Paul Mendel

5 years ago

Thank you for your comment. I will be adding items to the column and I want that the formula will always pull the last added item in the column. How do I do that? I am a real novice.

Gary Rosenzweig

5 years ago

Peter: I'm still uncertain whether you mean there will be empty cells at the bottom. Assuming now, then ROWS() inside an INDEX function is what you want. For instance if this is column B, then basically INDEX(B,ROWS(B)) gives you the value of the last cell in that row.