Please can someone help.
Please see screenshot here: Screenshot
There is a column where the user will select the CUSTOMER NAME from a drop-down menu, this will then automatically display the amount of skips that the customer has taken in the TOTAL SKIPS column.
The user will then input how many skips they would like to invoice by putting in the value in the column SKIPS TO INV, the last column OUTSTANDING, is basically the TOTAL SKIP minus SKIPS to INV (to give a total of how many skips are left to invoice).
The issue is that customers are not selected sequentially, thus I need a formula in the TOTAL SKIPS column that will display the last value from the OUTSTANDING column of the last instance of the customer name above.
E.g. When selecting customer name 1, the value displayed in column TOTAL SKIP will show the last value from the OUTSTANDING column of customer 1 which was 3 rows above.
Please see screenshot here: Screenshot
There is a column where the user will select the CUSTOMER NAME from a drop-down menu, this will then automatically display the amount of skips that the customer has taken in the TOTAL SKIPS column.
The user will then input how many skips they would like to invoice by putting in the value in the column SKIPS TO INV, the last column OUTSTANDING, is basically the TOTAL SKIP minus SKIPS to INV (to give a total of how many skips are left to invoice).
The issue is that customers are not selected sequentially, thus I need a formula in the TOTAL SKIPS column that will display the last value from the OUTSTANDING column of the last instance of the customer name above.
E.g. When selecting customer name 1, the value displayed in column TOTAL SKIP will show the last value from the OUTSTANDING column of customer 1 which was 3 rows above.