Hi,
I was wondering if anyone could help me solve a little problem I am currently experiencing. I am creating a load plan sheet for logistics purposes. Basically my data to look up against is a loading order onto a trailer, so fo eg
Loading Sequence
2
1
5
4
3
2
1
So every '1' is a trailer assigned, the countdown to one is drop order for the vehicle. So to he question, What I need is to create 'routes' so for eg
Loading Sequence
2
1 = route 1
5
4
3
2
1 = route 2
So the formula has to look down the data, and every time it finds a '1' it assigns a number, the first '1' would be 1, the second would be 2 and so on and so forth. The tricky part is for the forumla to look up the data it is returning to +1 to count up and return the ascending route number. Data below
<tbody>
</tbody><colgroup><col><col></colgroup>
Current Forumla =IF(C3=1,A2+1,0)
Any help would be greatly appreciated
Many Thanks Mick
I was wondering if anyone could help me solve a little problem I am currently experiencing. I am creating a load plan sheet for logistics purposes. Basically my data to look up against is a loading order onto a trailer, so fo eg
Loading Sequence
2
1
5
4
3
2
1
So every '1' is a trailer assigned, the countdown to one is drop order for the vehicle. So to he question, What I need is to create 'routes' so for eg
Loading Sequence
2
1 = route 1
5
4
3
2
1 = route 2
So the formula has to look down the data, and every time it finds a '1' it assigns a number, the first '1' would be 1, the second would be 2 and so on and so forth. The tricky part is for the forumla to look up the data it is returning to +1 to count up and return the ascending route number. Data below
Route | Delivery Sequence |
0 | 2 |
1 | 1 |
0 | 2 |
1 | 1 |
0 | 4 |
0 | 3 |
0 | 2 |
1 | 1 |
2 | 1 |
0 | 5 |
0 | 4 |
0 | 3 |
0 | 2 |
1 | 1 |
<tbody>
</tbody><colgroup><col><col></colgroup>
Current Forumla =IF(C3=1,A2+1,0)
Any help would be greatly appreciated
Many Thanks Mick