hi, have 5 columns of numbers that ascend in value from left to right,
if different col val is highest value.. use next column to right as the
new goal level.
thanks

have a long equation, that would get longer with more columns, is there a
way to use mod / range / offset (if embedding problem) to make formula more
efficient?

formula that otherwise works is:
=IF((EC9CL9)*(CL90),CM9,IF((EC9CK9)*(CK90),CL9 ,IF((EC9CJ9)*(CJ90),CK9,IF((EC9CI9)*(CI90),CJ9 ,CI9))))


other idea's:
other formulas used for adding every other column might be an idea, not sure..


=IF(AC33="","",SUM(--(MOD(COLUMN($AC33:$AK33),2)MOD(COLUMN($AC33),2)), $AC33:$AK33))

=IF(AC33="","",SUMPRODUCT(--(MOD(COLUMN($AB33:$AJ33),2)=MOD(COLUMN($AB33),2)), $AB33:$AJ33,$AC33:$AK33))