[Dba-office] Excel: sub-set of a page returns zero for blank
John R Bartow
jbartow at winhaven.net
Thu May 12 18:45:37 CDT 2016
I'm using Excel column referencing in this manner =IF(Office!B:B ="yes",
Office!J:J, "") to pull together certain columns of a the main "Office"
sheet into another sheet.
Unfortunately, regardless of cell formatting, if the referenced cell is
empty it returns a zero. How can I eliminate the zero?
Much of the referenced information in the subset sheet's column is plain
More information about the Dba-office