I am trying to populate the empty cells with the cell before it. How can I do that?
Thanks!!
Before:
After:
Solved! Go to Solution.
Hey @AmAm,
What you need is a multi row formula like this:
If you look at the tools configuration window, it updates my test column. In the formula it checks if the current column is empty then use the value of the row above. If you have any questions feel free to ask. If this answers your question give it a tick :)
All the best,
Ira
Thanks man!!