You could perhaps do this with the MCONCAT function available with the
MOREFUNC addin, download MOREFUNC from here
http://www.rhdatasolutions.com/morefunc/
then you could use this formula in D1 copied down column
=IF(A1=A2,"",A1&" "&MCONCAT(INDEX(C$1:C1,MATCH(A1,A$1:A1,0)):C1, " "))
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=512925