Forum Discussion
Solved
Trying to find a way to post a formula's result in two cells, not just the formula cell.
10/23/2019 108.38 0.19 110.29 10/24/2019 113.35 4.97 110.61 10/25/2019 113.71 0.36 110.94 111.69 10/28/2019 117.08 3.37 111.59 111....
=INDEX(H1:H7,MATCH(TRUE,NOT(ISBLANK(H1:H7)),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=INDEX(H1:H7,MATCH(TRUE,NOT(ISBLANK(H1:H7)),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.