[µo°Ý] ¦p¦ó±Nªí®æ¤ºªº¸ê®ÆÂàÅܬ°¥X³f³æ¼Ë¦¡¡H

bvge

½Ð¬Ýªþ¥ó¤ñ¸û²M·¡
¤]´N¬O­n§Q¥Îª÷ÃB¤u§@ªíªº¸ê®ÆÂàÅܬ°¥X³f³æ³oºØ®æ¦¡

§Ú¥Ø«e¬O¥Î¿z¿ïªº¤è¦¡(¿ï«DªÅ®æ)¡A¦A±N¸ê®ÆCOPY¨ì¥X³f³æ
µM«á§ó§ïªíÀYªº°Ï°ì¦WºÙ³Ì«á¦C¦L¥X¨Ó

§xÂZ¡G
²Ä¤@°Ï¿z¿ï§¹¤§«á¡A­n±N¿z¿ï¸ê®Æ¦^´_(¿ï¥þ³¡)¡A³o¼Ë¤~¯à°µ²Ä¤G°Ï¿z¿ï
¦Ó¥BÁÙ­n±N²Ä¤@°ÏÁôÂð_¨Ó¡A³o¼ËCOPY¤~¤£·|COPY¨ì²Ä¤@°Ï¸ê®Æ
¦p¦¹¤ÏÂСA24­Ó¦a°Ï­n­«½Æ24¦¸¡A²Ö¦º¤H¤F¡I

«ô°U«e½ú­Ì
À°§Ú·Q·Q¿ìªk¡A¬Ý¯à§_²¤Æ¡A©Î¬O¥Î¨ä¥L¤èªk
¥u­n¯à°÷¥Îª÷ÃB¤u§@ªíªº¸ê®ÆÂàÅܬ°¥X³f³æ³oºØ®æ¦¡´N¥i¥H
ÁÂÁ¡I

¹s¥ó.rar (45.62 KB)

¤U¸ü¦¸¼Æ: 18

2011-2-20 17:24

bvge

Hsieh ¶Wª©§A¦n

¥i¥H¤F
·PÁÂ
¦A·PÁ¡I

Hsieh

¦^´_ 5# bvge


    E8°}¦C¤½¦¡
{=IF(ROW(A1)-COUNT(y)=2,COUNT(y)&"   ¶µ¥Ø",IF((ROW($A1)-COUNT(y)>0),"",INDIRECT("¼Æ¶q!R"&SMALL(IF(y<>"",ROW(y),""),ROW($A1))&"C"&MATCH(¼Æ¶q!$D$1,¼Æ¶q!$3:$3,0),0)))}
¬õ¦âªº2´N¬OªÅ¤@¦C¶ñ¤J¶µ¥Ø¼Æ
§ï¦¨3´NªÅ¥Õ2¦C¡A¥H¦¹Ãþ±À

bvge

Hsieh ¶Wª©§A¦n
«Ü·PÁ±zÀ°§U¡A¹ê¦b«Ü¤è«K¤S¦n¥Î
¦A½Ð°Ý¤@¤U
E8°}¦C¤½¦¡
¸ê®Æ»P X¶µ¥Ø¬O¹jµÛ¤@¦CªÅ¥Õ
¦pªG­n¹jµÛ¤G©Î¤T¦CªÅ¥Õ¤£ª¾¹D­n­×§ï¨º¸Ì
¤~¯àÅý¸ê®Æ»PX¶µ¥Ø¬O¹jµÛ¤G©Î¤T¦CªÅ¥Õ
·q½Ð¦AÀ°¦£
ÁÂÁ¡I

¹s¥ó.rar (86.16 KB)

¤U¸ü¦¸¼Æ: 8

2011-3-6 10:34

bvge

½Ð°Ý Hsieh ¶Wª©
¨Ì·Ó§Aªº¤½¦¡¤Î°}¦C±a¤J³£¨S¦³¥X²{¿ù¹L°T®§
À³¸Ó¬O¦bH6ÅçÃÒ¿ï¾Ü¦a°Ï«á´N·|Åã¥Ü¸Ó°Ïªº¸ê®Æ
¦ý¬O¿ï¾Ü«á³£¬O¤@¹MªÅ¥Õ

¤S­«°µ¤@¦¸
©w¸q "y" ¦WºÙ®É·|´M§ä ¥X³f³æ "¤½¦¡" ªº¦ì¸m.....
¬O¤£¬O³o½t¬G¡H

§ÚÅv­­¤£°÷µLªk¤U¸ü¡I

ANGELA

¦^´_ 1# bvge


    ¸Õ¸Õ.
A6=INDEX(ª÷ÃB!$A$1:$A$150,SMALL(IF(ISNUMBER(OFFSET(ª÷ÃB!$A$4:$A$150,,MATCH(ª÷ÃB!$F$3,ª÷ÃB!$A$3:$AC$3,)-1)),ROW($B$4:$B$150),150),ROW(A1)))&""
CTRL+SHIFT+ENTER °}¦C¤½¦¡
¦V¥k¦V¤UCOPY
E6=INDEX(ª÷ÃB!$F$1:$F$150,SMALL(IF(ISNUMBER(OFFSET(ª÷ÃB!$A$4:$A$150,,MATCH(ª÷ÃB!$F$3,ª÷ÃB!$A$3:$AC$3,)-1)),ROW($B$4:$B$150),150),ROW(E1)))&""
E12=SUMPRODUCT(ISNUMBER(--A6:A11)*1)&"    ¶µ¥Ø"

Hsieh

¦^´_ 1# bvge
©w¸q¦WºÙ
x=ª÷ÃB!$F$3:$AC$3
y=OFFSET(ª÷ÃB!$A$3,1,MATCH('¥X³f³æ(¤½¦¡)'!$H$6,ª÷ÃB!$3:$3,0)-1,146,)
**************************************
H6ÅçÃÒ:²M³æ=x
**************************************
C1="ªA°È¹s¥ó¥æ³f©ú²Óªí ("&MID(H6,FIND(CHAR(10),H6),256)&")"
A8:C8°}¦C¤½¦¡
=IF(ROW($A1)>COUNT(y),"",INDIRECT("ª÷ÃB!R"&SMALL(IF(y<>"",ROW(y),""),ROW($A1))&"C",0))
D8°}¦C¤½¦¡
=IF(ROW($A1)>COUNT(y)+6,"",IF(ROW($A1)-COUNT(y)>0,CHOOSE(ROW($A1)-COUNT(y),"","Á`­p¥»§å¦@¥æ³f¡G","","¦@     ¥ó","","¦¬³fñ³¹¡G"),INDIRECT("ª÷ÃB!R"&SMALL(IF(y<>"",ROW(y),""),ROW($A1))&"C",0)))
E8°}¦C¤½¦¡
=IF((ROW($A1)-COUNT(y)=1)+(ROW($A1)>COUNT(y)+2),"",IF(ROW(A1)-COUNT(y)=2,COUNT(y)&"   ¶µ¥Ø",INDIRECT("ª÷ÃB!R"&SMALL(IF(y<>"",ROW(y),""),ROW($A1))&"C"&MATCH($H$6,ª÷ÃB!$3:$3,0),0)))
*****************************************
F8=IF(B8="","",VLOOKUP(B8,Sheet3!$A$2:$D$100,4,FALSE))

¤U¸ü (28.19 KB)

2011-2-21 10:29

¹s¥ó.rar (55.77 KB)

¤U¸ü¦¸¼Æ: 10

2011-2-21 10:30