| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide formula in cells till data is available for calc
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hide formula in cells till data is available for calc
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 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking in Formula cell to follow its cells that contain calc data | Excel Discussion (Misc queries) | |||
| How can i Change Autofilter data from top till bottom in macro | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| The Excel cells are not automatically calc. existing formula. | Excel Worksheet Functions | |||
Linear Mode
