arbelkasim
New member
- Joined
- Aug 6, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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.
attached file with examples.
View attachment Book1.xlsx
* 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.
attached file with examples.
View attachment Book1.xlsx