How to saving values from a calculation

[Guest]

I have a column of input values that I keep a rolling average of the previous
5. There are also blank rows in the column that are not to be averaged. I
set up a column with the count function counting only cells with values.
When count is great than 5 it moves the data in column 1 to another column
and the other 4 using count -4. The new data takes the old data our because
the are now a new 5 to be averaged. An IF function with a sum of the new
column are used to average the 5. As new data is input into the column a
function averages the new line of data and the previous 4 non blank entries.
Is there a way to save each of my calculations or averages for future use?
Is ther any way to "lock" the data in a cell when put in the first time?
Thank you for any help.

 

[Myrna Larson]

You can convert a formula to its value with Edit/Paste Special, and select the
Values option.

 

[bobclark]

or for us old keyboarders
alt-e s v


On Sat, 30 Oct 2004 23:55:42 -0500, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:

~>You can convert a formula to its value with Edit/Paste Special, and select the
~>Values option.
~>
~>
~>>I have a column of input values that I keep a rolling average of the previous
~>>5. There are also blank rows in the column that are not to be averaged. I
~>>set up a column with the count function counting only cells with values.
~>>When count is great than 5 it moves the data in column 1 to another column
~>>and the other 4 using count -4. The new data takes the old data our because
~>>the are now a new 5 to be averaged. An IF function with a sum of the new
~>>column are used to average the 5. As new data is input into the columna
~>>function averages the new line of data and the previous 4 non blank entries.
~>>Is there a way to save each of my calculations or averages for future use?
~>>Is ther any way to "lock" the data in a cell when put in the first time?
~>>Thank you for any help.

 

[Ragdyer]

Hey Folks,
I think you both forgot the first, most important "COPY" !
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
or for us old keyboarders
alt-e s v


On Sat, 30 Oct 2004 23:55:42 -0500, in microsoft.public.excel.misc falling
into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:

~>You can convert a formula to its value with Edit/Paste Special, and select
the
~>Values option.
~>
~>On Sat, 30 Oct 2004 19:32:01 -0700, Ron <[email protected]>
wrote:
~>
~>>I have a column of input values that I keep a rolling average of the
previous
~>>5. There are also blank rows in the column that are not to be averaged.
I
~>>set up a column with the count function counting only cells with values.
~>>When count is great than 5 it moves the data in column 1 to another
column
~>>and the other 4 using count -4. The new data takes the old data our
because
~>>the are now a new 5 to be averaged. An IF function with a sum of the new
~>>column are used to average the 5. As new data is input into the column a
~>>function averages the new line of data and the previous 4 non blank
entries.
~>>Is there a way to save each of my calculations or averages for future
use?
~>>Is ther any way to "lock" the data in a cell when put in the first time?
~>>Thank you for any help.

 

[Guest]

Thank you for help, but I need it to be done automatically. I guess htat is
where my problem lies. When the function computes I need the value saved
before the next calculation. edit, spacial, value works, but I need it ot be
automatic. Any ideas? Thank you.

 

[bobclark]

I hate it when I do that!!!

On Sun, 31 Oct 2004 07:23:21 -0800, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:

~>Hey Folks,
~>I think you both forgot the first, most important "COPY" !