Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I guess this should be very simple but ...
If I have a column with let's say 6 records (unsorted amounts) and every day I am adding a new record to the next cell until (e.g.) 20 values then I want that one cell shows the most recent value that has been input in the row, so that one which has the lowest position in this column - is there a formula that can do it? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |