I would like to generate the list of Songs for each of the CD collection I have based on a auto-generated listing (I can't afford to do manual work by Sorting the list and filtering it).

Previously I used this formula for generating the list for other things.. which involved names so that is no problem. But this time, I am using it for text rather so the function "small" can't be used.
=IF(ROW($A2)-1>COUNTIF(Collection,$B$5),"",INDEX(Song,SMALL(IF(Collection=$B$5,ROW(Song)),ROW($A2)-1)))

Column A is a blank column
'Collection' is the Array of all Collection Names say in another worksheet's Column T
'Song' is the Array of all Song Names say in another worksheet's (Same worksheet as 'Collection' Array) Column D
Cell B5 refers to the location of the Criteria.

I have tried searching the net and the forum but to no avail. Anyone can help? I have to do something like that for my school project. Thanks in advance! =)

Jas