当前位置: 动力学知识库 > 问答 > 编程问答 >

Is there any formula in excel to fetch end value of range in column?

问题描述:

This question already has an answer here:

  • excel function to find last number in column

    2 answers

网友答案:

You could perhaps use LOOKUP:

=LOOKUP(9^99,A:A)

This fetches the last numeric value in the column A. 9^99 is just an arbitrary value. If you had 1, the function would have fetched 1, if you had 2, the function would have fetched 2. Putting 9^99 would look for 9^99 and if it doesn't find one, it will give the last number it tried to match.

分享给朋友:
您可能感兴趣的文章:
随机阅读: