Hiding blank rows

M

mlkpied

I have a spreadsheet with columns, first name, last name, home phone,
business phone and cell phone. When I don't have phone information in any of
the three columns I would like that column to be hidden or deleted. Can I do
this in some automated fashion? Thanks. Michael
 
B

bj

try adding a column
in that column put something like
=if(counta(b2-d2)>0,"",1)
and use autofilter to hide the 1s
 
Top