How to move value on some criteria

[Sancho81]

Hello. I have a worksheet with some columns of values. I have columns with hours, price and amount (as seen in picture). I have to optimize the amount by ordering it in hours with largest price. That is not a problem, with LARGE, MATCH and INDEX functions it worked well (see Optimized amount). But now I have a column with level restrictions (see Level). And therefore I have to move value of optimized amount to match the level as soon as it reaches 72. If the level is less than 72 nothing should be moved. How could I do that?

 

[skillilea]

Can you wrap Optimized Amt in an IF >= 72 or Add another column to do the cal always and check?
Maybe I don't understand what the "Ask" is?

 

[Sancho81]

Hi, thank you for the effort. Sorry if I can not explain properly.
I got an Optimized Amt, it is perfect, but I have an other criteria ->Level. As soon as level reaches 72, I have to reorder Optimized Amt in such a way that one of the values is moved up to match the Level 72.
For example, in this case I need to move the value of Opt Amt 100 which matches the less price at Hour 24 to Hour 13 to match the Level 72.07. Total sum of Opt Amount should not be changed. When the Opt Amt is moved to match the Level, it is recalculated and sets in boundaries again (it is my further calculations). I added an image of that it would look like.

Is it even possible to do in excel? In a workbook I have a large amount of data.