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