Is there a formula that returns the number at the bottom of a list
Hi there,
I have a column that lists numbers for rows 3 to 100. What I'm wondering is
there a formula that will give me the current "bottom" number?
ex.
ColB
2
3
5
12
14
14
9
0
0
1
The formula would give 1, as it is the bottom number in the list. Now if I
added a 3 below the 1, the formula would then give 3, as it is the new bottom
number in the column.
Thanks!
Matt
|