ML089

¦^´_ 1# starry1314


=IF(COUNTA(F40,C40,H40)=0,"",F40&CHAR(10)&C40&"("&H40&")")

ML089

¦^´_ 4# starry1314


    À³¸Ó¬O©w¸q¦WºÙªº°ÝÃD¡A¤£ª¾§Aªº¦WºÙ¦p¦ó©w¸q

ML089

¦^´_ 8# starry1314

A2 =IF('¼ÐÅҼƾÚ(¦­À\)'!J2&'¼ÐÅҼƾÚ(¦­À\)'!K2&'¼ÐÅҼƾÚ(¦­À\)'!L2="","",'¼ÐÅҼƾÚ(¦­À\)'!J2&CHAR(10)&'¼ÐÅҼƾÚ(¦­À\)'!K2&"("&'¼ÐÅҼƾÚ(¦­À\)'!L2&")")

¦]¬°J K L¬°¤½¦¡¡AÁöµM¦^¶Ç""¦ý¹ïCOUNTA¨ç¼Æµø¬°¦³¸ê®Æ¤º®e

ML089

¦^´_ 10# starry1314

¤£¥Î®æ¦¡¤Æ¡A«e­±ªº¤½¦¡§Ú¤w¸g§ï¦n¤F¡A®M¥Î´N¥i¥H¡C

¥t¥~§Ú¬Ý§A¨CÄ檺¤½¦¡¬O¸õ19¦C¡A¨CÄæ³£­n­×§ï«Ü³Â·Ð¡A¤U¦C¤½¦¡¥u­n§A¥k©Ô½Æ»s¤½¦¡®É·|¦Û°Ê¸õ19¦C
A2 =IF(COUNT(0/(T(OFFSET('¼ÐÅҼƾÚ(¦­À\)'!$J2,COLUMN(A1)*19-19,{0,1,2}))=""))=3,"",OFFSET('¼ÐÅҼƾÚ(¦­À\)'!$J2,COLUMN(A1)*19-19,)&CHAR(10)&OFFSET('¼ÐÅҼƾÚ(¦­À\)'!$K2,COLUMN(A1)*19-19,)&"("&OFFSET('¼ÐÅҼƾÚ(¦­À\)'!$L2,COLUMN(A1)*19-19,)&")")

¥k©Ô¤U©Ô½Æ»s¤½¦¡