G
Guest
I want to preserve the "empty" status of cells from one sheet to another so
that when they are plotted or averaged they behave correctly. For example,
the initial sheet has some values that are not declared (read as ",,," in a
CSV file). A second sheet is used to assemble parts of the first sheet for
analysis and uses "paste link". However, "paste link" makes empty cells from
the first sheet into zeros on the second. I can use an IF() to test for zero
(but not empty?) and then make them either "" or na(). However, making them
"" is fine for average() but not good for a chart, which assumes they are
zero. Making them NA() is good for charts but no good for average(). Is there
a function that simply replicates the keystroke of 'delete'?
that when they are plotted or averaged they behave correctly. For example,
the initial sheet has some values that are not declared (read as ",,," in a
CSV file). A second sheet is used to assemble parts of the first sheet for
analysis and uses "paste link". However, "paste link" makes empty cells from
the first sheet into zeros on the second. I can use an IF() to test for zero
(but not empty?) and then make them either "" or na(). However, making them
"" is fine for average() but not good for a chart, which assumes they are
zero. Making them NA() is good for charts but no good for average(). Is there
a function that simply replicates the keystroke of 'delete'?