I have an incredibly difficult travelling salesman problem to work out.

I need help writing a formula that will accomplish the following:

sum from row 1 to row ? until the sum does not exceed 1100, then start
summing from the next row until it does not exceed 1100, etc. Ideally I
would like to assign a series number to each of those sets. For example,
the first set of rows whose sum <=1100 would be assigned a '1', and then
the next set a '2', and so forth.

The attachment might help to illustrate. See the column in bold...
right now it is set up manually, but i need a formula i can copy down
so when i optimize with solver it will all work out.

thanks-
k


--
krzys_28
------------------------------------------------------------------------
krzys_28's Profile: http://www.excelforum.com/member.php...o&userid=33759
View this thread: http://www.excelforum.com/showthread...hreadid=535325