One might be able to organize this neatly by using two sheets. The
first one can contain the 800 rows of original data. The second
contains 800 rows of data calculated as for row 3 below, using cross
referencing between the two sheets. The answers can be computed in
either sheet as convenient, in fact you might never have to look at
the 2nd sheet explicitly once it has been set up.
On Nov 10, 2008, at 17:59, Graham Smith wrote:
2008/11/10 Robertson Dale A. <[EMAIL PROTECTED]>:
If yoare willing to use an extra row you can simplify the top
enormously.
In row 2 we have C2, D2, E2,....
in row 3,columnC put "=C2*(C2-1). copy and paste this across the
row (as far
as column G in the example. Then the numerator can be evaluated
simply as
sum(c3:g3).
The denominator is simple enough as it is.
As I will have a about 800 rows of data, this probably isn't a
realistic solution in this case.
Thanks,
Graham
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
