Thanks a lot Tom, it worked! One more thing... How can I find the sum
for the last segment as well from lines 7 to 10? from the last yes to
the eof?

1 3 Yes
2 6 0
3 8 0
4 11 Yes
5 12 0
6 16 Yes
7 14 0
8 3 0
9 13 0
10 2 0


Thanks.
Trevor


--
Tre_cool
------------------------------------------------------------------------
Tre_cool's Profile: http://www.excelforum.com/member.php...o&userid=26416
View this thread: http://www.excelforum.com/showthread...hreadid=396852