Difference from an average

[Guest]

I want to automatically calculate a difference from and average. However when
the average changes, I don't want the previously calcuated differences to
change. Is there anyway to accomplish this?

For Example:

Score 45 46 44 45 (Average = 45)
Diff 0 +1 -1 0

What I would like to have aith adding 1 score

Score 45 46 44 45 50 (Average =46)
Diff 0 +1 -1 0 +4

 

[Paul Lautman]

I want to automatically calculate a difference from and average.
However when the average changes, I don't want the previously
calcuated differences to change. Is there anyway to accomplish this?

For Example:

Score 45 46 44 45 (Average = 45)
Diff 0 +1 -1 0

What I would like to have aith adding 1 score

Score 45 46 44 45 50 (Average =46)
Diff 0 +1 -1 0 +4

After calculating them, Copy and Paste Values.

 

[MHAlexander]

I want to automatically calculate a difference from and average. However when
the average changes, I don't want the previously calcuated differences to
change. Is there anyway to accomplish this?

For Example:

Score 45 46 44 45 (Average = 45)
Diff 0 +1 -1 0

What I would like to have aith adding 1 score

Score 45 46 44 45 50 (Average =46)
Diff 0 +1 -1 0 +4

Hi Larry,

I would use a macros to capture the old difference as a hard-coded
value in a third line called "Previous difference".

In that macro, I would take the following steps:

Check for existence for data in that third line. If no data, then
proceed with the macro.
Copy the values from the the difference formulas
Paste as values in to the third line.

I would use this macro in the Workbook_SheetChange event.

-Mike
www.datapigtechnologies.com