问题描述:

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.

相关阅读:
Top