One way would be to use this formula in B1

=A1

then in B2 copied down as far and more than you need

=IF(ROWS(B$2:B2)=SUMPRODUCT((A$1:A$1000<"")/COUNTIF(A$1:A$1000,A$1:A$1000&"")),"",INDEX(A$1:A$ 1000,MATCH(TRUE,INDEX(ISNA(MATCH(A$1:A$1000,B$1:B1 ,0)),0),0)))


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119890