J
John
I have a table of information to where I want to sort based on some conditions and constraints. I want to sort by Earliest Due Date but I have constraints to where I can only have one part number run on a given day and I have only a daily capacity of 100 hours. I want the table of information sorted quickly based on those conditions to where it sorts the information based on Earliest Due Date in blocks of 100 hours and the part numbers only show up once per 100 hour block. If a part number has two work orders with early due dates, I want it only to keep the one with the earliest date and then kick the next work order into the next block of 100 hours and so on and so forth...I hope this makes sense and I would appreciate any help on how to do this. Thanks
John
John