Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
118
Views
Topic starter
I have a list of all purchase orders that details the calculation of the balance on the annual bill. In the knight annual order by supplier I can see the remaining amount that is still open the PO. However, I see the same remaining amount in all lines and not the corresponding remaining amount per line for which a goods receipt was posted. Does anyone know of a way how this can be implemented so that I can see the current amount per row. An example is attached
Posted : 03/02/2023 2:14 pm
If you are using Excel 2021 or 365 then the XLOOKUP function will work.
You could also then update all your formulas with the newer functions like MAXIFS MINIFS etc...
Here is an attached modification
Posted : 04/02/2023 3:20 am