Picking Number And Placing in Between Two number

[dxzaber]

[TABLE="width: 200"]
<tbody>[TR]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i Will to put value in fist column (A) . i want Second column's Blank cell to recognize intermediate value from first Column .Like B2 cell will find 2 as 2 is between 1 & 3

 

[AlanY]

try this

=SUMPRODUCT(($A$1:$A$3>B1)*($A$1:$A$3" < "B3),$A$1:$A$3)

delete the " in formula

 

[My Aswer Is This]

Why no 6 in column "A"

Show us a sample of before and after.

 

[dxzaber]

https://docs.google.com/spreadsheets/d/15sFVGqiKm01qSQpHcVEgWf08Y294bnE5nAEX-1WJEhs/edit?usp=sharing

Check this ...i will put value in column A
Yellow Cells in Column B will recognize Value between it's Upper & lower cell from column A ...EX B3 cell will show 3 ..B9>>7 So on

 

[dxzaber]

It Works . Thanks For your help

 

[dxzaber]

It works .Thanks for your help <br><br>

try this<br>
<br>
=SUMPRODUCT(($A$1:$A$3>B1)*($A$1:$A$3<font color="#FF0000">" </font><<font color="#FF0000"> "</font>B3),$A$1:$A$3)<br>
<br>
delete the <font color="#FF0000">" </font>in formula

<br>
<br>

 

[AlanY]

You're welcome