Forum Discussion
olliecoopersiddle
May 06, 2018Copper Contributor
Hiding duplicate Formula Cells Until a value has been input
I'm creating a sheet with 3 columns: date, running total, and invoice amount.
When I input a new invoice amount it puts the new total in the running total box.
I've just dragged the formula down for 100 rows but now I have 100 rows worth of duplicate values, is there a way to hide these? Either by hiding duplicates or showing a blank cell until the source cell has had a value inputted. File attached.
Thanks.
Hi,
You can prefix the formula in cell B3 with some conditions as follows:
=IF(OR(B2="",C2=""),"",B2-C2)
Regards
2 Replies
Sort By
- Haytham AmairahSilver Contributor
Hi,
You can prefix the formula in cell B3 with some conditions as follows:
=IF(OR(B2="",C2=""),"",B2-C2)
Regards
- olliecoopersiddleCopper ContributorPerfect! Thank You