ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¨D§U´M§ä²Ä¤Gµ§¸ê®Æªº¼gªk

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-12-11 23:42 ½s¿è

AF27¤½¦¡
=IF(COLUMN(A27)/3>COUNTIF(µûµ¥ªí!$A:$A,LEFT($T27,4)),"",INDEX(µûµ¥ªí!$C:$E,MATCH(LEFT($T27,4),µûµ¥ªí!$A:$A,)+INT((COLUMN(A27)-1)/3),MOD(COLUMN(A27)-1,3)+1))

¥k©Ô½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# ML089
¯uªº·PÁÂ,¤w§¹¥þ¥i¥H¥Î¤F

TOP

¦^´_ 12# yan2463
¦A½Ð±Ð¤@­Ó°ÝÃD,­Y§Ú·Q§â¸ê°T¼W¥[¨ìHÄæ(6Äæ¬°¤@²Õ)
§Ú­n§ï¨º­Ó¦a¤è

TOP

¦^´_ 11# ML089
·Q¦A½Ð±Ð¤@­Ó°ÝÃD,·Q¼W¥[¸ê°T6Äæ¬°¤@²Õ,
À³¸Ó­×§ï¨º¸Ì

TOP

¦^´_ 14# yan2463

C6
­ì¬°
=IF(COLUMN(B6)/3>COUNTIF(µûµ¥ªí!$A:$A,$B6),"",INDEX(µûµ¥ªí!$C:$E,MATCH($B6&"",µûµ¥ªí!$A:$A,)+INT((COLUMN(B6)-2)/3),MOD(COLUMN(B6)-2,3)+1))
§ï¬°
=IF(COLUMN(B6)/6>COUNTIF(µûµ¥ªí!$A:$A,$B6),"",INDEX(µûµ¥ªí!$C:$H,MATCH($B6&"",µûµ¥ªí!$A:$A,)+INT((COLUMN(B6)-2)/6),MOD(COLUMN(B6)-2,6)+1))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 15# ML089
·PÁÂ¥¿¦b¨Ï¥Î¤¤

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD