MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Find the Last Number In a Column?

In Numbers, I have a column of numbers. I want to pull the last number in that column from that Sheet to another Sheet. How can I do that?
—–
Peter Paul Mendel

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

    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.

    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.

Comments Closed.