Dec 30 2021 10:00 AM
I have money amounts in a column that are entered daily. I.E. A1 100000, A2 101000 etc.. I want to be able to automatically transfer the amount entered that day to a another cell I.E. B4. So as I enter an amount in A1 in goes to B4, the next day A2 now shows in B4 and so on. I've been trying the offset function but without success. Can anyone help?
Dec 30 2021 10:11 AM
=INDEX(A1:A19,LARGE(IF(A1:A19<>"",ROW(1:19)),1))
Is this what you are looking for? Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.
Dec 30 2021 10:39 AM
Dec 30 2021 10:52 AM
I work with Excel 2013 as well. It works in my attached spreadsheet.
Dec 30 2021 11:41 AM
Dec 30 2021 12:09 PM
The formula in cell B4 displays the 18 from cell A8 in cell B4.
If you enter for example 107 in cell A9, the formula in B4 will show 107 in B4.
If you then enter for example 274 in cell A10, the formula in B4 will show 274 in B4.
The same was done when i entered the numbers in cells A1:A7.
Dec 30 2021 12:18 PM