Forum Discussion
Solved
Replace cells where there is no formulas behind, with a cell where there is a formula behind
Several cells where there is no formulas behind should be replaced in one workflow with a cell where there is a formula behind with relative references. How can it be done? Best Regards ...
Dear Jan Karel Pieterse
Thank's for your answer :-).
I forgot to describe that in the cells without formula behind, there is a time format with the time 00:30:00. The cells do not necessarily stand side by side, but may have empty cells between them.
Best Regards
n-b_j
Dear Jan Karel Pieterse
Thank's for your answer :-).
I forgot to describe that in the cells without formula behind, there is a time format with the time 00:30:00. The cells do not necessarily stand side by side, but may have empty cells between them.
Best Regards
n-b_j
In order to select those cells you could use find, if they all contain the same value you can click Find all. Then you can drag over the list of found items, close the dialog and enter the formula as I described already.
Dear Jan Karel Pieterse
Yes, in the meantime before you answered, I found the solution myself.
Best Regards
n-b_j