Tuesday, 13 August 2013

=IFERROR(INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),17)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),18)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),19)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),20)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),21)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),22)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),23)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),24)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),25)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),26)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),27)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),28)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),29)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),30)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),31)),"")
=IFERROR(INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),1)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),2)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),3)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),4)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),5)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),6)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),7)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),8)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),9)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),10)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),11)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),12)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),13)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),14)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),15)),"")&
IFERROR(", "&INDEX(Sheet2!$B$2:$B$32,SMALL(IF(Sheet2!$A$2:$A$32=A2,ROW(Sheet2!$A$2:$A$32)-ROW(Sheet2!$A$2)+1),16)),"")