mark15jill

¦^´_ 6# Iuy762102896


    ¿ù»~°T®§ºI¹Ï¤W¨Ó§a£¾£¾

Iuy762102896

Hsieh ¤j¤j~§Ú¦³½Æ»s§A»¡­n©ñ¦bA2ªºµ{¦¡~~¥i¬O§Ú¤@ª½¥X²{¿ù»~~~§Ú§ä¤£¥X­ì¦]...

Iuy762102896

¦n¶}¤ß³á>"<­ì¨Ó¯uªº¥i¥H°µ¨ì¡A·PÁ¦U¦ìªºÀ°¦£¡AÀɮקکñ¦b¤½¥q>"<
©ú¤Ñ¶Ç¤W¨Ó~~
¤£¹Lµ{¦¡¦³¤F¡A¦ý¬O§Úµ{¦¡­n©ñ¦b­þ¸Ì®º~~
Hsieh ¤j¤j  ¡A§AªºÀɮקڵLÅv¥i¥H¤U¸ü0.0

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

c_c_lai

¦^´_ 1# Iuy762102896
½Ð¤W¶ÇÀɮסA¦p¦¹¤j®a³£¯àÁA¸Ñ¥B©ö©ó¨ó§U©p¡C

mark15jill

¬O¦³¿ìªk°Ú...

¥H¤U¬O³Ì²©ö¨Ò¤l ¦b+°j°é §Y¥i¹F¨ì±z·Q­nªº

¨Ò¦p
if  sheets("¤é³øªí").range("e2").value="«È¶D" then sheets("«È¶D").range("e2").value =  sheets("¤é³øªí").range("e2").value

end if