Good Evening,
I have a workbook that contains a list of orders amongst vast other information.
These orders may have 1-100 lines(sequences) against them but split into multiple due dates with further sequences listed as a later due date.
As we anticipate the first order of the first five sequences with the same due date will be invoiced first - I want to show these lines as one order in a different column and also if its just one line show this as one order, Ive tried a MAXIF function but I don't really understand it.
Please can someone help?
Any help would be appreciated.
I have a workbook that contains a list of orders amongst vast other information.
These orders may have 1-100 lines(sequences) against them but split into multiple due dates with further sequences listed as a later due date.
As we anticipate the first order of the first five sequences with the same due date will be invoiced first - I want to show these lines as one order in a different column and also if its just one line show this as one order, Ive tried a MAXIF function but I don't really understand it.
Please can someone help?
Any help would be appreciated.