Sorting with Conditions-This is a tough one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a huge spreadsheet containing part numbers, work order numbers, labor time, and due dates. Here are the constraints

1. Cannot exceed certain amount of labor hours in one day (For this example let's use 10 hours
2. Cannot repeat the same part number within that block of 10 hour
3. Work must be sorted by due date within 10 hour block (that's the easy part

Look at the example below

Part Number W.O. Labor Time (Hours) Due Dat
A 100 2 1/1/0
A 101 2 1/1/0
B 200 3 1/2/0
B 201 3 1/2/0
C 300 4 1/1/0

Sorted Report Should Like the following

Part Number W.O. Labor Time (Hours) Due Dat
A 100 2 1/1/0
C 300 3 1/1/0
B 200 4 1/2/0
Page Break or Empty Ro

Part Number W.O. Labor Time (Hours) Due Dat
A 101 2 1/1/0
B 201 3 1/2/04

Anyone that can solve this is a master in my book.....thanks
 
I think you have incorrect finished sorts.

are you sure they are meant to be like this
 
Oops, you're right. Below should be the correct sorted version


Sorted Report Should Like the following

Part Number W.O. Labor Time (Hours) Due Dat
A 100 2 1/1/0
C 300 4 1/1/0
B 200 3 1/2/0
Page Break or Empty Ro

Part Number W.O. Labor Time (Hours) Due Dat
A 101 2 1/1/0
B 201 3 1/2/0

----- MattShoreson > wrote: ----

I think you have incorrect finished sorts

are you sure they are meant to be like this
 
This sort is impossible to do with the data, sort menu item.

Think you are going to have to sort by due date then split the dat
according to w.o. by code
 
I don't think this can be done under normal Excel channels without adding VB code to it. Unfortunately, I cannot write code. Any suggestions?
 
Back
Top