Highlighting the last number in sequence based on the same order number and due date

Bvendett4

New Member
Joined
Apr 10, 2018
Messages
24
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.
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,099,774
Messages
5,470,707
Members
406,718
Latest member
waseem11

This Week's Hot Topics

Top