Is there a formula that returns the number at the bottom of a list

  • Thread starter Thread starter mpenkala
  • Start date Start date
M

mpenkala

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
 
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
Click to expand...


=LOOKUP(1E+307,B:B)
--ron
 
Back
Top