Forum Discussion
Excel / Auto Hide Rows
FOR EX.
Below represents 4 rows and 2 columns of data that are populated from a different tab inside my spreadsheet.
I want to create a formula that automatically hides the entire row labeled E2 b/c there is not a number in the second column.
Is there an easy formula for this?
| TAKEOFF 1 | 3,554 | Tons |
| ~Piers | 3,553.5 | Tons |
| E1 | 3,553.53 | Tons |
| E2 | - | Tons |
There is nothing in what you just posted that suggests you even read the prior response. Did you? Did you try either of the ideas presented there? So far as I know there is no formula, per se, that would hide the row although--as suggested in my prior response--it depends on what you mean by "hide."
The FILTER function would do it, on a separate page. And there was even a link to a page with instructions on how to use it.
Otherwise you're looking at a macro or a VBA routine, and that's not my field of expertise.