Hello,
I'm trying to hide rows that have a zero value in them, but everytime i put a code in the whole silly sheet hides!!
YEAR FLOORS STATUS INITIATOR (If Planned)
2012 All Planned Landlord
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
Thats what I get with my IF formula - now I just want to hide the 0 rows until they are populated with valid criteria. so Hide rows if value = 0 .... Please help!
I remember another way to do this about 4 years ago ... with a filter option maybe but I just can't remember.
Bookmarks