Calculate Lowest Value By The Length

[sanju2323]

[TABLE="class: grid, width: 312, align: left"]
<tbody>[TR]
[TD="colspan: 2"]Calculate Lowest Value At Length[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Length[/TD]
[TD]Requirement[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]25.000[/TD]
[TD]10.000[/TD]
[TD]17.000[/TD]
[/TR]
[TR]
[TD]17.000[/TD]
[TD]15.000[/TD]
[TD]17.000[/TD]
[/TR]
[TR]
[TD]33.000[/TD]
[TD]30.000[/TD]
[TD]17.000[/TD]
[/TR]
[TR]
[TD]18.000[/TD]
[TD]40.000[/TD]
[TD]17.000[/TD]
[/TR]
[TR]
[TD]33.000[/TD]
[TD]49.000[/TD]
[TD]17.000[/TD]
[/TR]
[TR]
[TD]47.000[/TD]
[TD]60.000[/TD]
[TD]17.000[/TD]
[/TR]
[TR]
[TD]66.000[/TD]
[TD]63.000[/TD]
[TD]17.000[/TD]
[/TR]
[TR]
[TD]21.000[/TD]
[TD]88.000[/TD]
[TD]17.000[/TD]
[/TR]
[TR]
[TD]41.000[/TD]
[TD]90.000[/TD]
[TD]17.000[/TD]
[/TR]
[TR]
[TD]98.000[/TD]
[TD]100.000[/TD]
[TD]5.000[/TD]
[/TR]
[TR]
[TD]45.000[/TD]
[TD]111.000[/TD]
[TD]5.000[/TD]
[/TR]
[TR]
[TD]70.000[/TD]
[TD]118.000[/TD]
[TD]5.000[/TD]
[/TR]
[TR]
[TD]5.000[/TD]
[TD]126.000[/TD]
[TD]5.000[/TD]
[/TR]
[TR]
[TD]54.000[/TD]
[TD]133.000[/TD]
[TD]5.000[/TD]
[/TR]
[TR]
[TD]36.000[/TD]
[TD]164.000[/TD]
[TD]5.000[/TD]
[/TR]
[TR]
[TD]47.000[/TD]
[TD]174.000[/TD]
[TD]5.000[/TD]
[/TR]
[TR]
[TD]12.000[/TD]
[TD]183.000[/TD]
[TD]5.000[/TD]
[/TR]
[TR]
[TD]15.000[/TD]
[TD]200.000[/TD]
[TD]14.000[/TD]
[/TR]
[TR]
[TD]66.000[/TD]
[TD]210.000[/TD]
[TD]14.000[/TD]
[/TR]
[TR]
[TD]14.000[/TD]
[TD]220.000[/TD]
[TD]14.000[/TD]
[/TR]
[TR]
[TD]45.000[/TD]
[TD]230.000[/TD]
[TD]14.000[/TD]
[/TR]
[TR]
[TD]68.000[/TD]
[TD]240.000[/TD]
[TD]14.000[/TD]
[/TR]
[TR]
[TD]21.000[/TD]
[TD]250.000[/TD]
[TD]14.000[/TD]
[/TR]
[TR]
[TD]75.000[/TD]
[TD]260.000[/TD]
[TD]14.000[/TD]
[/TR]
[TR]
[TD]77.000[/TD]
[TD]270.000[/TD]
[TD]14.000[/TD]
[/TR]
[TR]
[TD]17.000[/TD]
[TD]290.000[/TD]
[TD]14.000[/TD]
[/TR]
[TR]
[TD]83.000[/TD]
[TD]300.000[/TD]
[TD]45.000[/TD]
[/TR]
[TR]
[TD]45.000[/TD]
[TD]325.000[/TD]
[TD]45.000[/TD]
[/TR]
[TR]
[TD]83.000[/TD]
[TD]345.000[/TD]
[TD]45.000[/TD]
[/TR]
</tbody>[/TABLE]


Please give me excel formula

 

[Aladin Akyurek]

What result do you expect to get?

 

[sanju2323]

I Want Calculate Min Value By Length (Range) "100"

 

[Snakehips]

sanju2323,

Perhaps something along these lines...

Excel 2007
	A	B	C
1	Calc @		100
2	A	Length	Answer
3	25	10	17
4	17	15	17
5	33	30	17
6	18	40	17
7	33	49	17
8	47	60	17
9	66	63	17
10	21	88	17
11	41	90	17
12	98	100	5
13	45	111	5
14	70	118	5
15	5	126	5
16	54	133	5
17	36	164	5
18	47	174	5
19	12	183	5
20	15	200	14
21	66	210	14
22	14	220	14
23	45	230	14
24	68	240	14
25	21	250	14
26	75	260	14
27	77	270	14
28	17	290	14
29	83	300	45
30	45	325	45
31	83	345	45
Sheet2

Cell Formulas
Range	Formula
C3	{=MIN(IF(INT($B$3:$B$31/100) = INT($B3/100),$A$3:$A$31*(INT($B$3:$B$31/100)=INT($B$3:$B$31/100))))}
Press CTRL+SHIFT+ENTER to enter array formulas.

Hope that helps.

 

[sanju2323]

Thank You Sir Its Good Work

 

[Aladin Akyurek]

I Want Calculate Min Value By Length (Range) "100"

Does this have a value? If yes, that's what I was asking for...