Forum Discussion

olliecoopersiddle's avatar
olliecoopersiddle
Copper Contributor
May 06, 2018
Solved

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.

Resources