Here's another way...

C1:

=SUMPRODUCT((A1:A6<"")/COUNTIF(A1:A6,A1:A6&""))

B1, copied down:

=IF(ROWS($B$1:B1)<=$C$1,INDEX($A$1:$A$6,MATCH(SMAL L(IF(($A$1:$A$6<"")*(COUNTIF(OFFSET($A$1,0,0,ROW( $A$1:$A$6)-ROW($A$1)+1),$A$1:$A$6)=1),COUNTIF($A$1:$A$6,"<"&$ A$1:$A$6)),ROWS($B$1:B1)),COUNTIF($A$1:$A$6,"<"&$A $1:$A$6),0)),"")

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

ceemo Wrote:
Hi i have the following which gives me unique alpha's in order but when
it has produced all possible entry's it diplays an error.

=INDEX($A$1:$A$6,MATCH(SMALL(IF(($A$1:$A$6<"")*(C OUNTIF(OFFSET($A$1,0,0,ROW($A$1:$A$6)-ROW($A$1)+1),$A$1:$A$6)=1),COUNTIF($A$1:$A$6,"<"&$ A$1:$A$6)),ROWS($B$1:B1)),COUNTIF($A$1:$A$6,"<"&$A $1:A$6),0))


I have tried using the below but it didnt work and it made the cell
very large
=if(iserror(formula)=true,"",formula


Can anyone help?


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