Hello,
please someone can help me?
I want to extract from a file:
for any material code the last data, qty and price from a lot of movement.
| material | data | qta | Price |
| a | 17/01/2017 | 1 | 10 |
| a | 18/01/2017 | 2 | 11 |
| a | 19/01/2017 | 3 | 12 |
| a | 20/01/2017 | 4 | 13 |
| a | 21/01/2017 | 5 | 14 |
| b | 21/02/2017 | 5 | 20 |
| b | 22/02/2017 | 4 | 21 |
| b | 23/02/2017 | 3 | 22 |
| b | 24/02/2017 | 2 | 23 |
| b | 25/02/2017 | 1 | 24 |
| c | 17/03/2017 | 1 | 30 |
| c | 18/03/2017 | 2 | 31 |
| c | 19/03/2017 | 3 | 32 |
| c | 20/03/2017 | 4 | 33 |
| c | 21/03/2017 | 5 | 34 |
| Result |
| a | 21/01/2017 | 5 | 14 |
| b | 25/02/2017 | 1 | 24 |
| c | 21/03/2017 | 5 | 34 |
tks in advance.
Marco
