View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yiannis5231 yiannis5231 is offline
external usenet poster
 
Posts: 1
Default Formula to find the last number of a column (lower cell)

I have a column with numbers. I want a formula that it will be finding the
lower cell that has data. For example in column A i have numbers in cells A1,
A2 and A3. In cell A10 i want a fotmula. With this formula will see in cell
A10 the number that i have in cell A3. If i put a number in cell A4 i want
that number to be shown in cell A10.