Please help me in the following, I have a table that contains the following date:

* A - inquiry no.
* B - quotation no.
* C - amount

Where quotation number will be changed by adding 1,2, or 3 according to revision while keeping the same inquiry number. When revising the quotation, the Amount can be changed also.

I need to find the last revised quotation for each inquiry and get the amount of it.

Book1.xlsx

attached file with examples.