First, have your table start on the second row. Therefore, if A2:B8
contains your table...

C1: =MAX(A2:A8)

D1: enter a 0 (zero)

D2, copied down:

=IF((A2<"")*(A2=$C$1),LOOKUP(9.99999999999999E+30 7,$D$1:D1)+1,"")

E1:

=LOOKUP(9.99999999999999E+307,D:D)

F2, copied down:

=IF(ROW()-ROW(F$2)+1<=$E$1,INDEX(B$2:B$8,MATCH(ROW()-ROW(F$2)+1,$D$2:$D$8,0)),"")

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=275236