Thank you very much for your kind help
The values shown in yellow highlights starting from Cell B 249 are the values obtained using a set of formulas calculated above. Each time the values are recalculated using the F9 tab, the chk fn will get updated. The values of chk fn in the cell B 249 needs to be compared with the next obtained value after recalculation and if the chk fn value is less, it should be updated in cell B264 , otherwise retain the values. The values shown in blue highlights starting from B 264 should represent the values corresponding to the chk fn. So that the lowest value for chk fn should be obtained after several recalculations in cell B264 and the corresponding values in the blue highlighted area. The problem is shown in the attached screenshot. Please help me in this regard.
Bookmarks