Hello everyone,
I am coming across with coming up a formula to summarize the description.
basically I would like to find the Serial number in column A. If it is other or reserve, then no further steps to be taken, other than that, I would like to find the respective payment type, period start, period and in column K,L,M and retrieve the value in column F.
the lines marked in red are the expect results.
Thank you very much in advance for your help!
Let me know if you Need further clarification.
Best regards
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>
I am coming across with coming up a formula to summarize the description.
basically I would like to find the Serial number in column A. If it is other or reserve, then no further steps to be taken, other than that, I would like to find the respective payment type, period start, period and in column K,L,M and retrieve the value in column F.
the lines marked in red are the expect results.
Thank you very much in advance for your help!
Let me know if you Need further clarification.
Best regards
Serial No. | Month | Invoice Type | Invoice No. | Supplier | Description | Amount gross | Tax | Tax amount amount | Net Amount | Payment type | Period Start | Period End |
7522 | jun-18 | Payment | 84445 | GE | Assessment_fee_01.04-30.04.2018_SN_7522 | $ 71.000,00 | 0 | $ - | $ 71.000,00 | Assessment_fee | 01.04 | 30.04.2018 |
7523 | jun-18 | Payment | 84446 | GE | Evaluation_fee_01.05-31.05.2018_SN_7523 | $ 45.226,83 | 0 | $ - | $ 45.226,83 | Evaluation_fee | 01.05 | 31.05.2018 |
7524 | jun-18 | Payment | 84447 | GE | $ 174.966,00 | 0 | $ - | $ 174.966,00 | ||||
7525 | jun-18 | Payment | 84448 | GE | $ 45.000,00 | 0 | $ - | $ 45.000,00 | ||||
8522 | jun-18 | Payment | 89542 | GE | $ 35.818,00 | 0 | $ - | $ 35.818,00 | ||||
65442 | jun-18 | Payment | 89549 | GE | $ 795.153,00 | 0 | $ - | $ 795.153,00 | ||||
6542 | jun-18 | Payment | 89588 | GE | $ 66.500,00 | 0 | $ - | $ 66.500,00 | ||||
other | jun-18 | Payment | 89842 | GE | $ 2.000.000,00 | 0 | $ - | $ 2.000.000,00 | ||||
other | jun-18 | Payment | 88542 | GE | $ 100.850,99 | 0 | $ - | $ 100.850,99 | ||||
Reserve | jun-18 | Payment | 13050 | GE | $ 54.000,00 | 0 | $ - | $ 54.000,00 | ||||
Reserve | jun-18 | Payment | 13049 | GE | $ 52.500,00 | 0 | $ - | $ 52.500,00 | ||||
85236 | jun-18 | Payment | SR959-05-18-I | GE | $ 24.800,00 | 0 | $ - | $ 24.800,00 | ||||
V78852 | jun-18 | Payment | 852 | GE | $ 67.095,00 | 0 | $ - | $ 67.095,00 | ||||
895532 | jun-18 | Payment | 853 | GE | $ 47.310,00 | 0 | $ - | $ 47.310,00 | ||||
8889 | jun-18 | Payment | 5551 | GE | $ 1.000,00 | 0 | $ - | $ 1.000,00 | ||||
Reserve | jun-18 | Payment | 88820 | GE | $ 599,97 | 0 | $ - | $ 599,97 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>