Empty strings appear as zeros
While awaiting a reply, I had already employed Jon Peltier's method of
an additional set of calculations, which is working fine, though I was
hoping there was a solution with less redundancy. As much as I don't
want to leave array formulas in the hands of users, Andy Pope's and
Dave Curtis' suggestions look quite appealling as it will remove the
need for a separate sheet and second data set. Both solutions are
equally valid, depending on preference.
Thanks guys for each of your replies.
|