Formula problem

[acw]

Mike

Assuming that the cd name starts in A2 and the song starts
in B2 of sheet 1 and continues down:

1) in C2 enter the formula
=IF(COUNTIF($A$2:A2,A2)=1,ROW(A2),"x")
and copy down.
2) in A1 of sheet 2, enter the formula
=INDEX(Sheet1!A:A,SMALL(Sheet1!C:C,ROW()))
and copy down.

This will give you a unique list of the cd names, but they
won't be sorted. If you want them sorted, then sort the
data in sheet 1 by CD name.

HTH

Tony