View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mpenkala mpenkala is offline
external usenet poster
 
Posts: 90
Default 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