On Tue, 18 Jan 2005 16:24:27 -0000, "Chris Ferguson"
wrote:

Hi Richard

Does the answer have to be in one column or can it be in a number of columns
most of which can be hidden?

That way you could have another table alongside the original table with a
formula to pick up the corresponding value if that is the last value and
then have the last column picking up the max value in the row.

So F1 would be =A1-A1*(SUM(B1:$E1)<0)

And G1 would be =B1-B1*(SUM(C1:$E1)<0)

etc

And K1 would be =MAX(F1:J1)

You could then hide columns F to I



Hope this helps



Chris

Chris,

Many thanks for this idea.

I never cease to be amazed by the speed of response in this ng, and
particularly the clever ways people have found of overcoming problems.
Even where suggestions are not exactly what's required, there's often
a good idea to be tucked away for next time.

Kind regards,

Richard

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________