Excel if column is hidden a diffrent columns cell equals text -
is there way have cell return value if column hidden,
example - if column "a" hidden cell "b1" equal "text"
place formula in cell b1.
=if(cell("width",a1)=0,"text","")
is there way have cell return value if column hidden,
example - if column "a" hidden cell "b1" equal "text"
place formula in cell b1.
=if(cell("width",a1)=0,"text","")
Comments
Post a Comment