Try this revised sample construct (see sheet: Z)
http://cjoint.com/?cwm4iib2Zz
Extract uniques list in sorted alpha order_v2.xls

In the new sheet: Z,
With A1:B1 housing the name of the races
Slightly revised formula in A2 (to extract for all races)

Put in A2:
=IF(ISERROR(SMALL($C:$C,ROW(A1))),"",
INDEX(OFFSET(X!$A:$A,,MATCH(A$1,X!$1:$1,0)-1),MATCH(SMALL($C:$C,ROW(A1)),$C:
$C,0)))
Copy A2 to B2

Put in C2 (no change):
=IF(X!A2="","",IF(COUNTIF(X!$A$2:A2,X!A2)1,"",COD E(UPPER(LEFT(X!A2,1)))+ROW
()/10^10))

Select A2:C2, fill down to say, C10, to cover
the max expected extent of data in X's col A

Sheet Z returns the complete spread for all races

Note that the alpha-sort order is an approx one,
done only using the 1st letter, so it won't be perfect <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"marshall" wrote in message
...
Thank you max. However I don't want a seperatel ist of horses for each
race
I just want to add the next race to the exsisting list so that I can
scroll
down and see which horses are entered in which races and then print off
the
master list.

Can I do that with your formula?

Thank you for your time