Hsieh

¦^´_ 1# Iuy762102896
¨C­Ó¤lªí³æªºA2°}¦C¤½¦¡
=IF(COUNTIF(¸ê®Æ!$D$2:$D$5,MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2))+1=ROW($A1),"¥H¤UªÅ¥Õ",IF(COUNTIF(¸ê®Æ!$D$2:$D$5,MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2))<ROW($A1),"",OFFSET(¸ê®Æ!$A$1,SMALL(IF(¸ê®Æ!$D$2:$D$5=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2),ROW($2:$5),""),ROW($A1))-1,COLUMN()-1)))
¦V¥k¦V¤U½Æ»s
¤ÀÃþ.rar (11.46 KB)

¤U¸ü¦¸¼Æ: 18

2012-11-21 20:42

¤U¸ü (232.53 KB)

2012-11-22 22:59

Hsieh

¦^´_ 9# Iuy762102896

¥²¶·¨Ï¥Î°}¦C¤½¦¡
¿é¤J¤½¦¡«á¥Hctrl+shift+enter§¹¦¨¿é¤J

Hsieh

¦^´_ 12# Iuy762102896


    ¦]À³¸ê®Æ¼W¥[¥²¶·¨Ï¥ÎÅܰʽd³ò
·s¼W¤@­Ó©w¸q¦WºÙ
ng°Ñ·Ó¨ì¤½¦¡=OFFSET(¸ê®Æ!$D$1,,,COUNTA(¸ê®Æ!$D:$D)-1,)
¦U¤À­¶A2°}¦C¤½¦¡
=IF(COUNTIF(rng,MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2))+1=ROW($A1),"¥H¤UªÅ¥Õ",IF(COUNTIF(rng,MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2))<ROW($A1),"",OFFSET(¸ê®Æ!$A$1,SMALL(IF(rng=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2),ROW($2:$5),""),ROW($A1))-1,COLUMN()-1)))
¦V¤U¦V¥k½Æ»s