I need help to auto hide columns if the result of a cell (with firmula) returns value (blank or #N/A) other than numbers:
Case:
cell G5 to Z5 will capture and show invoice numbers from a summary sheet if formula criterials are met. (i.e. G5 to Z5 contain formulas), if not, it will be blank (i use IF and ISNA to 'convert' #N/A to blank). Is it possible to auto hide column with 'blank' result?
Please advise!
Thanks!
Case:
cell G5 to Z5 will capture and show invoice numbers from a summary sheet if formula criterials are met. (i.e. G5 to Z5 contain formulas), if not, it will be blank (i use IF and ISNA to 'convert' #N/A to blank). Is it possible to auto hide column with 'blank' result?
Please advise!
Thanks!