Prev: Word prints Excel does not!
Next: Delete entire row if older then 365 days
From: kiwi on 3 Apr 2010 18:02
I recall being able to copy a formula in a column and hiding it until data
becomes available to complete the calculation. This way you don't have a
series of #value# in the work sheet.
The formula contains an absolute reference as well.

Thanks,

Kiwi
From: Gord Dibben on 3 Apr 2010 19:52
A look at your formula would have been nice.

=IF(cellref="","",do something) traps for cellref having no data.


Gord Dibben MS Excel MVP

On Sat, 3 Apr 2010 15:02:01 -0700, kiwi <kiwi(a)discussions.microsoft.com>
wrote:

>I recall being able to copy a formula in a column and hiding it until data
>becomes available to complete the calculation. This way you don't have a
>series of #value# in the work sheet.
>The formula contains an absolute reference as well.
>
>Thanks,
>
>Kiwi

 | 
Pages: 1
Prev: Word prints Excel does not!
Next: Delete entire row if older then 365 days