This question already has an answer here:
excel function to find last number in column
You could perhaps use
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
9^99 would look for
9^99 and if it doesn't find one, it will give the last number it tried to match.