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

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

make that =LOOKUP(1000000000,A3:a100)


"mpenkala" wrote:

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

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

say your data is in column A

=vlookup(1000000000000,A3:a100)


"mpenkala" wrote:

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

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

On Mon, 4 Feb 2008 12:14:01 -0800, mpenkala
wrote:

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


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

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

On Mon, 04 Feb 2008 15:40:56 -0500, Ron Rosenfeld
wrote:

=LOOKUP(1E+307,B:B)

Since you specified rows 3:100, you can change the above to, for example:

=LOOKUP(1E+307,B3:B100)
--ron