ANGELA

¤U¸ü (80.62 KB)

2012-9-30 19:19

1101:1203ªºO1=RIGHT(ªí¦W,4)
i1=CELL("filename",INDIRECT(1100+ROW(A1)&"!a1"))
j1={RIGHT(IF(tot<ROW(),"",INDEX(I:I,SMALL(IF(ISTEXT($I$1:$I$200),ROW($A$1:$A$200)),ROW(A1)))),4)}
k1=IF($J1="","",IF(INDIRECT($J1&"!"&"i253")="ªÅ","ªÅ",""))

B1{=INDEX(J:J,SMALL(IF($K$1:$M$20="ªÅ",ROW($A$1:$A$20),99),ROW(1:1)))&""}
C1=IF($J1="","",VLOOKUP(B2,J1:K9,2,))
©w¸q¦WºÙ
tot=COUNTA(Á`ªí!$I$1:$I$300)-SUM(ISERROR(Á`ªí!$I$1:$I$300)*1)
ªí¦W=CELL("filename",!C1)

pilied2k

§¹³J¤F  §Ú³£¨S¦³vbaªº°ò¦
ÁÙ¦³¨S¦³±Ïªü

ANGELA

¦hºûÁÙ¬O¥Îvba·|²³æ¨Ç,¤½¦¡­n¥Î¨ì¸É§U¦C¤Î©w¸q¦WºÙ«Ü³Â·Ð.

pilied2k

½d¨Ò-­×§ï.rar (85.37 KB)

¤U¸ü¦¸¼Æ: 8

2012-9-30 12:04

ÁÂÁª©¤j´£¿ô
§Ú·Q¥ý±N°ÝÃD²³æ¤Æ  
²Å¦X±ø¥ó ¥u­n­ÓªÑ¤À­¶¹ïÀ³¬d¸ßªº¤é´Á ¸Ó (°T¸¹1)¬°"ªÅ"
«h³£¶×¤JÁ`ªí³o¸Ì   
³o¼Ë¤£ª¾¯à§_¥i¦æ

ANGELA

²Å¦X±ø¥ó,¬O²Å¦X¤°»ò±ø¥ó,­nÅý§O¤H¤F¸Ñ§Aªº»Ý¨D,¤~¯àÀ°¤W¦£.
§A½d¨Òªº¸ê®ÆÀ³¬Ocopy¤U¨Óªº©Ò¥H¬Ý¦ü¤é´Á,¨ä¹ê¤£¬O,254¦C¬Ý¦üªÅ®æ¨ä¹ê¤]¤£¬OªÅ®æ
5¼Ó¬O°²³]¤wª¾A2ªº¤é´Á¤ÎB2:B4ªº¥N¸¹¨D¥XªºC3¨ìE4ªºµ²ªG

pilied2k

¤U¸ü (20.93 KB)

2012-9-30 11:23

½Ð°Ýª©¥D  ¤é´Á­n§ï¦¨¤°»ò¼Ëªº¤é´Á®æ¦¡

§Ú°µ³o­Ó¥Øªº ¥D­n¬O·Q¿é¤J¤é´Á
Åý¦U¤À­¶²Å¦X±ø¥óªº­ÓªÑ
¦Û°Ê¦bÁ`ªí¨q¥X¨Ó  ¨S²Å¦X±ø¥óªº­ÓªÑ´N¤£·|¥X²{
©Ò¥H  ¤é´Á®æ¦¡Áٳ·Ъ©¤j´£¿ô±Ð¾É

ANGELA

=VLOOKUP(LOOKUP(2,1/($A$1:$A2<>""),$A$1:$A2),INDIRECT($B2&"!a:K"),COLUMN(I1),)
¦P¤@­Ó¤½¦¡©¹¤U©Ô¤£¯àÅã¥Ü¤£¦Pªºµ²ªG.¤é´Á³Ì¦n¥Î¤é´Á®æ¦¡,¤è«K­pºâ
=VLOOKUP(LOOKUP(9^9,$A$1:$A2),INDIRECT($B2&"!a:K"),COLUMN(I1),)

pilied2k

½d¨Ò.rar (86.2 KB)

¤U¸ü¦¸¼Æ: 6

2012-9-30 10:44

°µ³o¼Ë½Õ¾ã
³Â·Ð¤F

ANGELA

²Å¦Xªº±ø¥ó¬O¤°»ò?¬Ý¤£¥X¨Ó,¬O¦hÁÙ¬OªÅ.

pilied2k

½d¨Ò.rar (86.01 KB)

ªí®æ
¤U¸ü¦¸¼Æ: 3

2012-9-30 09:46

­è§Ñ¤F¤W¶Ç