hi i have the following which sorts my data but would like it to only
include unique records. can and how would i do this?

INDEX($A$1:$A$6,MATCH(SMALL(IF($A$1:$A$6="","",COU NTIF($A$1:$A$6,"<"&$A$1:$
A$6)),ROW(A1)),IF($A$1:$A$6="","",COUNTIF($A$1:$A$ 6,"<"&$A$1:$A$6)),0))


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=392116