Just for the record, replace my first formula with the following...

B1, copied down:

=N(OFFSET($A$1,SMALL(IF($A$1:$A$100<0,ROW($A$1:$A $100)-CELL("row",B$1)),
ROW()+ROW(B2)-2),0))

C1, copied down:

=N(OFFSET($A$1,SMALL(IF($A$1:$A$100<0,ROW($A$1:$A $100)-CELL("row",C$1)),
ROW()*2),0))

Hope this helps!

In article ,
Domenic wrote:

I'm not sure if this will do, but see it the following helps. Assuming
that Column A contains your numbers...

1) Select B1:C1

2) With those two cells highlighted, enter the following array formula,
that needs to be confirmed with CONTROL+SHIFT+ENTER, and copy down:

=N(OFFSET($A$1,SMALL(IF($A$1:$A$100<0,ROW($A$1:$A $100)-CELL("row",$B$1))
,COLUMN(INDIRECT(CHAR(65+(ROW()*2-2))&":"&CHAR(65+(ROW()*2-2)+1)))),0))

...adjust the range accordingly.

3) D1, copied down:

=B1&":"&C1

Hope this helps!