Hello,
I have a spreadsheet with multiple columns, where I created an IF statement to add the total values in the relevant cells and if the total = zero, I return the phrase "hide" These become the rows I want to hide until we updated values next period.
This is for a department level P&L, unique tab for each, I will reset the data each month.
Appreciate any help / insight.
I have a spreadsheet with multiple columns, where I created an IF statement to add the total values in the relevant cells and if the total = zero, I return the phrase "hide" These become the rows I want to hide until we updated values next period.
This is for a department level P&L, unique tab for each, I will reset the data each month.
Appreciate any help / insight.