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?”

    2 months 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
    2 months 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.

    2 months 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.

Leave a New Comment Related to "How Do I Find the Last Number In a Column?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)