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),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)),"")

No comments:

Post a Comment