How best to get rid of zeroes as a result of empty cells.
A formula in the destination worksheet creates a content based on the contents of a source spreadsheet. In doing so, if a cell is empty in the source worksheet, Excel puts a 0 in its place on the destination worksheet. The formula needs to perform this as the data is being created in the destination worksheet. How best to remove the zero in place of a blank (“”)?
=LET(
data,pi_pkgdata,
recordType,PI_Package!$A$7:$A$1600,
CHOOSECOLS(FILTER(data,(recordType=”PCODE”),”NO RECORDS”),4,158,59,60,58,42,11,12,13,14,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,15,16,139,140,17,19,21,23,25,18,20,22,24,26,157,141,142,143,144,145,146,147,148,149,150,151,152,153,154,41,155,156,49,47,48,46,159,160,161,162,163,164,165,166,167,168,169,170,43,171,44))
A formula in the destination worksheet creates a content based on the contents of a source spreadsheet. In doing so, if a cell is empty in the source worksheet, Excel puts a 0 in its place on the destination worksheet. The formula needs to perform this as the data is being created in the destination worksheet. How best to remove the zero in place of a blank (“”)? =LET(data,pi_pkgdata,recordType,PI_Package!$A$7:$A$1600,CHOOSECOLS(FILTER(data,(recordType=”PCODE”),”NO RECORDS”),4,158,59,60,58,42,11,12,13,14,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,15,16,139,140,17,19,21,23,25,18,20,22,24,26,157,141,142,143,144,145,146,147,148,149,150,151,152,153,154,41,155,156,49,47,48,46,159,160,161,162,163,164,165,166,167,168,169,170,43,171,44)) Read More