Share via

Excel function to find last value in a column

Anonymous
2022-05-18T17:27:51+00:00

I would like a function that looks at a column and selects the last entry in that column.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. DaveM121 871.8K Reputation points Independent Advisor
    2022-05-18T18:01:34+00:00

    Hi Carl,

    I am Dave, I will help you with this.

    You can use the formula below to get the last value in a column, I have used Column B as an example, you may need to change B to another column

    =LOOKUP(2,1/(B:B<>""),B:B)

    300+ people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-05-18T17:29:50+00:00

    I need a function that will search a column of data and return the last value in the column.

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2022-05-18T21:35:47+00:00

    It worked great! Thanks a lot Dave.

    7 people found this answer helpful.
    0 comments
  3. DaveM121 871.8K Reputation points Independent Advisor
    2022-05-18T18:40:00+00:00

    Hi Carl, glad to help!

    4 people found this answer helpful.
    0 comments
  4. Anonymous
    2022-05-18T18:38:07+00:00

    Thanks! I will give it a try.

    3 people found this answer helpful.
    0 comments