References Double extract the last

Good morning, I need your help.
A friend of mine gave me a file where the sheet 1 will have data in the A1 in Sheet2 you choose day and time.
After the choice I made a C-H column table that extracts only the data <= A1.
But there are several data that have the same column C ref and I should just pull the last as seen in the J-O table with colored cells.
And 'possible with formulas?
But to vary from A1 onwards there might still be the same ref.

For now I stop to avoid complicating the explanation
Thanks so much.

Meanwhile, I thank you for your cooperation.
There are still things that do not go.
I had explained everything before to not confuse things too much.
and 'a bit complicated to explain.

The R column must be in ascending order.

The F column indicates sheet1 with 3 order entered with 1 order eliminated with 0 executed order.

Line 2 sheet 1 C = 30000 column is in column F = 3
row 3 has sheet1 in column F = 1 and Ref in column A is equal to the line 2.
In this case an operation cancels the other and in Sheet2 should not be reported anything.

Those that column F = 1 and the column Ref A does not correspond to those which have in the F = 3 column should not be in Sheet2.

Finally, if column A ref = xxxy column C = 30000 Column F = 3
* and column A ref = xxxy column C = 20000 Column F = 1
It means that the order was canceled partially and should go on Sheet2 the difference 30000-20000 = 10000.
I hope I have been clear thanks again for your valuable help.

Hello Glenn, I understand that the request is not simple.
I apologize if I had originally exposed only part of the problem.
I tried to get something in your formula and more of my and I put in C2:

Please Login or Register  to view this content.

but it does not give me all the desired results.

If you think it's complicated thank you anyway for your commitment that you gave me.