| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Next lower cell with number... | Excel Worksheet Functions | |||
| if a number lower than 30 than the cell turns yellow?? | Excel Discussion (Misc queries) | |||
| how do I write the formula to find the mean in a column of number | Excel Worksheet Functions | |||
| Find DMIN in a column range determined by a number in another cell | Excel Worksheet Functions | |||
| How can I find the row nr of the first number lower/ higher then a | Excel Discussion (Misc queries) | |||
Linear Mode
