Forum Discussion
formula for excel
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 ent...
=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.
- Hi Thanks so much for the quick response, Its just returning zero. Sorry not very advanced with excel. working with excel 2013
I work with Excel 2013 as well. It works in my attached spreadsheet.
- Not sure I understand I see 18 in the second column. So you moved 18 from the bottom of the 1st column over to the second column? Did it work that way with the numbers above?
