ªð¦^¦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 : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD