Nat wrote...
....
The problem relates to the use of "" in the creation of data arrays.
....
I am in need of a simple solution that either 1) creates truly blank cells
in the original function used to create the array or 2) allows me to convert
those "blank cells" to cells that are recognized as being truly empty by the
Descriptive Statistics tool.
There's no direct solution because BLANK corresponds the the same value
as VBA's Empty, but there's no way to produce it in formulas. So your
option 1 can't be done. As for 2, the only thing you could do is clear
the nonnumeric cells. If you're using Edit Paste Special, Values to
produce your data ranges, then just after pasting press [F5], click on
the Special... button, select Constants and uncheck the Numbers check
box, and click OK. At this point, only the cells with nonnumeric values
would remain selected. Just press [Delete] to clear them.
|