问题描述:

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.