Mr. Excel: How to hide cells with #N/A value - there must be a way!
Posted by Thomas on October 16, 2000 4:22 PM
I have looked all thru the excel help and tried some wacky stuff myself, to no avail. I do not have the knowledge to write scripts but have recorded a few macros. The closest I've come to solving this problem was with conditional formatting (I don't care how they're hidden, so long as I don't have to look at them so my format was white text/white background), but entering na(), #n/a, or isna(cell in question) in the criteria doesn't do squat even when it accepts the formula syntax. WTFO?