Is there any way to hide a row in a formula?
Basically, I want a row to be hidden if a value is blank.
Table:
1 Item 1 33
2 Item 2 39
3 Item 3
4 Item 4 43
5 Item 5
6 Item 6
7 Item 7 21
8 Item 8 44
9 Item 9 50
10 Item 10 14
So in the above example I would like to hide rows 3, 5 and 6 if it is blank. The numbers in column 3 are generated by a formula, and could change over time, so I only want the row hidden when no value is there.
Is that possible?
Bookmarks