D
Dark Horse
In Excel, is there any way of performing two functions in the same
instruction cell?
I'm trying to stop a list of columns extending into infinity by finding
another way to calculate a running average.
In BASIC there would have been a way, and I just wonder if there is a way in
math spreadsheets?
I could have added A (the latest entry) to B, (the running total) and at the
same time added 1 to count (which was originally set to 1).
I could then just repeat this by adding any new data to A, which will add it
to B (and add 1 to count at the same time) and give me a running total which
I can divide by count.
Unfortunately my knowledge of Excel is not as good as my knowledge of BASIC
was, so I don't know if it can be done?
instruction cell?
I'm trying to stop a list of columns extending into infinity by finding
another way to calculate a running average.
In BASIC there would have been a way, and I just wonder if there is a way in
math spreadsheets?
I could have added A (the latest entry) to B, (the running total) and at the
same time added 1 to count (which was originally set to 1).
I could then just repeat this by adding any new data to A, which will add it
to B (and add 1 to count at the same time) and give me a running total which
I can divide by count.
Unfortunately my knowledge of Excel is not as good as my knowledge of BASIC
was, so I don't know if it can be done?