G
Guest
I am using an IF function to generate data for an array. Under certain
conditions a given cell should generate a totally blank cell, as opposed to a
zero value. I have been trying to use a formula such as:
=IF(A10>A1,A10,"")
The problem relates to the use of "" in the creation of data arrays.
Once the array has been created I have copied all of the formula results and
converted them to values, i.e. I have eliminated the formula and now merely
have an array of data that was created using a formula. I have been trying to
use the Data Analysis tool to run a Descriptive Statistics summary for each
column of the array. However, when attempting to do so I receive an error
message that says non-numeric information is included in the array, i.e. the
cells that appear empty are being recognized as non-numeric information.
Those cells were originally created as "" cells when using the function. I
know that I could locate each "blank" cell and delete its contents, which
works, but is infeasible as my data array is rather large.
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.
conditions a given cell should generate a totally blank cell, as opposed to a
zero value. I have been trying to use a formula such as:
=IF(A10>A1,A10,"")
The problem relates to the use of "" in the creation of data arrays.
Once the array has been created I have copied all of the formula results and
converted them to values, i.e. I have eliminated the formula and now merely
have an array of data that was created using a formula. I have been trying to
use the Data Analysis tool to run a Descriptive Statistics summary for each
column of the array. However, when attempting to do so I receive an error
message that says non-numeric information is included in the array, i.e. the
cells that appear empty are being recognized as non-numeric information.
Those cells were originally created as "" cells when using the function. I
know that I could locate each "blank" cell and delete its contents, which
works, but is infeasible as my data array is rather large.
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.