First i need to take the value 70.29 and follow next step.since the input is 80.29 .i have taken only 70.29 remaining value need to take from next value 10

Scenario 2: input value 80.29
Type. Value
A. 80.29
B. 10.00

First i need to take the value 80.29 and follow next step.since the input is 80.29 and the first value same as input need not proceed further taken valuefirst value only.

Scenario 3

Type. Value
A. 90.29
B. 10.00
Take only 80.29 from first row since the input is 80.29

Hi , What you want to do is always select the value close to the input value? If so, you can pretend to take the difference of the values in the datatable according to the input value and select the little difference.

First i need to take the value 70 and update in Excel next i need to take remaing value of 80 ie 70 is already taken so 10 need to be take and update in excel

Will there be a possibility of having an input in the below way ? :

Type. Value
A. 90.29
B. 10.00
C. 20.00
D. 80.29

or

Type. Value
A. 90.29
B. 10.00
C. 50.00
D. 30.29

In this case, we do have the input value, but the First value itself is greater than the input value , so do we stop and take the Input value or do we need to find the value (or sum of values that make the value) in the other consecutive cells ?

Let us know if the ordering is done first either Descending/Ascending or keep the received input as it is ?