Hello Gurus,
The following will output me the "I" character in the sequence of each True Cell in a range and a blank " " similarly.
=aconcat(IF(ISNUMBER(AI7:BB7),"l"," "))
I would like it give a blank " " for cell with formulas giving me 0 numbers also. It is giving "I" for 0 numbers.
will appreciate.
The following will output me the "I" character in the sequence of each True Cell in a range and a blank " " similarly.
=aconcat(IF(ISNUMBER(AI7:BB7),"l"," "))
I would like it give a blank " " for cell with formulas giving me 0 numbers also. It is giving "I" for 0 numbers.
will appreciate.