Repeat Calculation At Length & Calculate Lowest Value At Length

[sanju2323]

[TABLE="class: grid, width: 776"]
<tbody>[TR]
[TD="colspan: 3, align: center"]Repeat Calculation At Length
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"][/TD]
[TD="colspan: 2, align: center"]Calculate Lowest Value At Length
[/TD]
[TD="align: center"]100
[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]Length[/TD]
[TD="align: center"]Requirement[/TD]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]Length
[/TD]
[TD="align: center"]Requirement[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10.000[/TD]
[TD="align: center"]25.000[/TD]
[TD="align: center"]10.000[/TD]
[TD="align: center"]35.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]25.000[/TD]
[TD="align: center"]10.000
[/TD]
[TD="align: center"]17.000
[/TD]
[/TR]
[TR]
[TD="align: center"]15.000[/TD]
[TD="align: center"]27.000[/TD]
[TD="align: center"]15.000[/TD]
[TD="align: center"]42.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]17.000[/TD]
[TD="align: center"]15.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]150.000[/TD]
[TD="align: center"]29.000[/TD]
[TD="align: center"]30.000[/TD]
[TD="align: center"]179.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]33.000[/TD]
[TD="align: center"]30.000
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]170.000[/TD]
[TD="align: center"]31.000[/TD]
[TD="align: center"]40.000[/TD]
[TD="align: center"]201.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]18.000[/TD]
[TD="align: center"]40.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]240.000[/TD]
[TD="align: center"]33.000[/TD]
[TD="align: center"]49.000[/TD]
[TD="align: center"]273.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]33.000[/TD]
[TD="align: center"]49.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]301.500[/TD]
[TD="align: center"]35.000[/TD]
[TD="align: center"]60.000[/TD]
[TD="align: center"]336.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]47.000[/TD]
[TD="align: center"]60.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]363.000[/TD]
[TD="align: center"]37.000[/TD]
[TD="align: center"]63.000[/TD]
[TD="align: center"]400.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]66.000[/TD]
[TD="align: center"]63.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]424.500[/TD]
[TD="align: center"]39.000[/TD]
[TD="align: center"]88.000[/TD]
[TD="align: center"]463.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]21.000[/TD]
[TD="align: center"]88.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]486.000[/TD]
[TD="align: center"]41.000[/TD]
[TD="align: center"]90.000[/TD]
[TD="align: center"]527.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]41.000[/TD]
[TD="align: center"]90.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]547.500[/TD]
[TD="align: center"]43.000[/TD]
[TD="align: center"]100.000
[/TD]
[TD="align: center"]590.500
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]98.000[/TD]
[TD="align: center"]100.000
[/TD]
[TD="align: center"]5.000
[/TD]
[/TR]
[TR]
[TD="align: center"]609.000[/TD]
[TD="align: center"]45.000[/TD]
[TD="align: center"]111.000[/TD]
[TD="align: center"]590.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]45.000[/TD]
[TD="align: center"]111.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]670.500[/TD]
[TD="align: center"]47.000[/TD]
[TD="align: center"]118.000[/TD]
[TD="align: center"]654.000
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]70.000[/TD]
[TD="align: center"]118.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]732.000[/TD]
[TD="align: center"]49.000[/TD]
[TD="align: center"]126.000[/TD]
[TD="align: center"]717.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]5.000[/TD]
[TD="align: center"]126.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]793.500[/TD]
[TD="align: center"]51.000[/TD]
[TD="align: center"]133.000[/TD]
[TD="align: center"]781.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]54.000[/TD]
[TD="align: center"]133.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]855.000[/TD]
[TD="align: center"]53.000[/TD]
[TD="align: center"]150.000[/TD]
[TD="align: center"]844.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]53.000[/TD]
[TD="align: center"]150.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]916.500[/TD]
[TD="align: center"]55.000[/TD]
[TD="align: center"]155.000[/TD]
[TD="align: center"]908.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]55.000[/TD]
[TD="align: center"]155.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]978.000[/TD]
[TD="align: center"]57.000[/TD]
[TD="align: center"]164.000[/TD]
[TD="align: center"]971.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]36.000[/TD]
[TD="align: center"]164.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1039.500[/TD]
[TD="align: center"]59.000[/TD]
[TD="align: center"]174.000[/TD]
[TD="align: center"]1035.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]47.000[/TD]
[TD="align: center"]174.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1101.000[/TD]
[TD="align: center"]61.000[/TD]
[TD="align: center"]183.000[/TD]
[TD="align: center"]1098.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]12.000[/TD]
[TD="align: center"]183.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1162.500[/TD]
[TD="align: center"]63.000[/TD]
[TD="align: center"]200.000
[/TD]
[TD="align: center"]1162.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]15.000[/TD]
[TD="align: center"]200.000
[/TD]
[TD="align: center"]14.000
[/TD]
[/TR]
[TR]
[TD="align: center"]1224.000[/TD]
[TD="align: center"]65.000[/TD]
[TD="align: center"]210.000
[/TD]
[TD="align: center"]1225.500
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]66.000[/TD]
[TD="align: center"]210.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1285.500[/TD]
[TD="align: center"]67.000[/TD]
[TD="align: center"]220.000[/TD]
[TD="align: center"]1225.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]14.000[/TD]
[TD="align: center"]220.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1347.000[/TD]
[TD="align: center"]69.000[/TD]
[TD="align: center"]230.000[/TD]
[TD="align: center"]1289.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]45.000[/TD]
[TD="align: center"]230.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1408.500[/TD]
[TD="align: center"]71.000[/TD]
[TD="align: center"]240.000[/TD]
[TD="align: center"]1352.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]68.000[/TD]
[TD="align: center"]240.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1470.000[/TD]
[TD="align: center"]73.000[/TD]
[TD="align: center"]250.000[/TD]
[TD="align: center"]1416.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]21.000[/TD]
[TD="align: center"]250.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1531.500[/TD]
[TD="align: center"]75.000[/TD]
[TD="align: center"]260.000[/TD]
[TD="align: center"]1479.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]75.000[/TD]
[TD="align: center"]260.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1543.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]77.000[/TD]
[TD="align: center"]270.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]1606.500[/TD]
[TD="align: center"][/TD]
[TD="align: center"]89.000[/TD]
[TD="align: center"]280.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]0.000[/TD]
[TD="align: center"][/TD]
[TD="align: center"]17.000[/TD]
[TD="align: center"]290.000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]83.000[/TD]
[TD="align: center"]300.000
[/TD]
[TD="align: center"]83.000
[/TD]
[/TR]
</tbody>[/TABLE]


How To Calculate By The Formula ?

 

[Andrew Poulsom]

Please specify what you want to calculate and explain the expected result.

 

[sanju2323]

Please specify what you want to calculate and explain the expected result.

First Example- I Am Calculate A+B = Result,
I've given length is based on the results and This was the finish on the 100 length And Should Get A Duplicate Value and continued to calculate the next 100 length


Download To Sample Copy.
Excel Help Forum

 

[Andrew Poulsom]

Please read Forum Rule #10 here:

http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html