Hello,
I have a workbook that contains a list of orders amongst a vast amount of other information.
The orders are listed by a sales order due date from oldest to newest and are repeated multiple times but referencing different line items on that order(its almost safe to assume every order will have more than one line with the same due date)
What I am trying to determine is the amount of orders on the book between two dates specific ranges(our financial month).
The order count is constantly changing as we invoice orders off the system and take new orders to go in and out of the same month based on their due date.
I hope the below provides some clarity on what I am trying to achieve, so I need to calculate how many orders(not lines) we need to invoice but I don't want to ignore duplicate orders that have a different due date as this will be an additional invoice on a separate date within the month (I appreciate I could just pivot this but I need it to be constantly updating so I can measure our loading against what we can achieve).
All help will be appreciated.
I have a workbook that contains a list of orders amongst a vast amount of other information.
The orders are listed by a sales order due date from oldest to newest and are repeated multiple times but referencing different line items on that order(its almost safe to assume every order will have more than one line with the same due date)
What I am trying to determine is the amount of orders on the book between two dates specific ranges(our financial month).
The order count is constantly changing as we invoice orders off the system and take new orders to go in and out of the same month based on their due date.
I hope the below provides some clarity on what I am trying to achieve, so I need to calculate how many orders(not lines) we need to invoice but I don't want to ignore duplicate orders that have a different due date as this will be an additional invoice on a separate date within the month (I appreciate I could just pivot this but I need it to be constantly updating so I can measure our loading against what we can achieve).
All help will be appreciated.
HTML:
OrderNo
AccountName CustomerOrderNo AccountNo Line
DueDate BM84285 Koso Kent Introl Limited
1 K070 15 01/04/19 BM84285 Koso Kent Introl Limited 1 K070 20 01/04/19 BM84489 Gaffney-Kroese Supply Corp. 2 G085 5 01/04/19 BM85480 WT Petrotech USA Inc. 3 P516 5 01/04/19 BM85480 WT Petrotech USA Inc. 3 P516 10 01/04/19 BM85480 WT Petrotech USA Inc. 3 P516 15 01/04/19 BM85480 WT Petrotech USA Inc. 3 P516 20 01/04/19 BM85480 WT Petrotech USA Inc. 3 P516 25 01/04/19 BM85622 H2R Automation GMBH 4 H154 5 01/04/19 BM85633 H2R Automation GMBH 4 H154 5 01/04/19 BM85680 JOHN ZINK INT.LUXEMBOURG SARL 5 K063 6 01/04/19 BM85680 JOHN ZINK INT.LUXEMBOURG SARL 5
K063 15 01/04/19 BM84285 Koso Kent Introl Limited 1 T013 5 10/04/19