Robertson, > 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.
Yes, that would work, and indeed I did have something similar but on the same sheet at one time, but I think in this instance Brians single array formula approach is the way to go. Thanks for the help, Graham --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
