If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Formula to find the last number of a column (lower cell)
Try the below in cell A10
=LOOKUP(10^10,A1:A9) -- Jacob (MVP - Excel) "yiannis5231" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|