ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦h­¶¤u§@ªí¬D¥X²Å¦X¸ê®æ·J¾ã¨ì·sªº¤u§@­¶

aaa.gif
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)

TOP

½Ð°Ý  ª©¤j
©w¸q¦WºÙ
§Ú¸Ó¥h­þ°µ³]©w
¯à§_½Ðª©¤j  ±NÀÉ®×±H¨ì§Úªº«H½c [email protected]
Åý§Ú°Ñ¦Ò¤@¤U  §Ú¦b©w¸q¦WºÙ¨ºÃä¬Ý¤£À´
²M°ª ¯Ü®zªº°°¹¢

TOP

55.gif
2012-9-30 20:31

©w¸q  ªí¦W  ok
¦ý tot ©w¸q§¹ ¨S¤ÏÀ³
¬O§Ú¥Îoffice 2003ªºÃö«Y¶Ü?
²M°ª ¯Ü®zªº°°¹¢

TOP

¬ã¨s¤@¾ã±ß  ²×©óª¾¹D§Ú­þÃä¿ù¤F
¶K¤W¤½¦¡®É" {}"  ­n¥ý¥h±¼  µM«á«öCtrl+Shift+Enter  ´N·|¦Û°Ê²£¥Í
³o¼Ë§Ú´N§¹¥þ¥i¥H¿é¥X¸òªO¤j¶Kªº¹Ï¤ù¤@¼Ëªºµ²ªG¤F   «D±`·PÁÂ

ÁٽбЪO¤j  ¬°¦ó§Ú§ïÅܤé´Á«á  ¸ê®Æ³£¤£·|ÅÜ°Ê
¬O§Úªº¤é´Á®æ¦¡¿ù»~ÁÙ¬O­þÃä¥X¿ù
²M°ª ¯Ü®zªº°°¹¢

TOP

AÄæ¤é´Á¬Ý¦ü¤é´Á¡A¹ê»Ú¬O¤å¦r¼Ò¦¡¡C
¿ïAÄæ¡C¦A¥Î¸ê®Æ­åªR¡CÄæ¦ì¸ê®Æ®æ¦¡¿ï¤é´ÁªºYMD¡C
©Î¦b¥ô¤@Àx¦s®æ¿é¤J1¡A=> COPY =>¿ïAÄæ=>¥kÁä=>¿ï¾Ü©Ê¶K¤W=>­¼¡C¦A³]¦¨¤é´Á®æ¦¡¡C

TOP

122.gif
2012-10-1 10:53

½Ð±Ðª©¥D
§Ú§â¤é´Á§R°£  ½T¥i¥H¯d¤U¸ê®Æ  
µM¦Ó  §Ú¥u­n¦b
k=IF($J1="","",IF(INDIRECT($J1&"!"&CHAR(64+COLUMN(I1))&"253")="ªÅ","ªÅ",""))
§â253  §ó§ï252©Î251  ¸ê®Æ«K·|§ó§ï¤F
¨º»ò³o¼Ë¬Ý¨Ó  ¦n¹³¤é´Á¨ºÄæ¦ì  µL®Ä
¨S¿ìªk¥Ñ¤é´Á¨Ó¹ïÀ³¨ì·í¤éªº¸ê®ÆÄæ¦ì
²M°ª ¯Ü®zªº°°¹¢

TOP

k1=IF($J1="","",IF(INDIRECT($J1&"!i"&MATCH(A$2,INDIRECT(J1&"!a:a"),))="ªÅ","ªÅ",""))

TOP

½d¨Ò3.rar (87.61 KB)
·PÁª©¥D «ü¾É:victory:
¥i¥Ñ¤é´Á¥s¥X¸ê®Æ¤F
¥Ø«e³Ñ¤U³Ì«á¤@­Ó°ÝÃD¤F
­è§Ú´ú¸Õ®É   §Ú­Yª½±µ±N1101¤ºªº¤é´Á copy¶K¨ìÁ`ªí¤é´ÁÄæ¦ì®É   ¥i¥H°õ¦æ
¦ý  ­Y¤â°Ê¦bÁ`ªíªº¤é´ÁÄæ¦ì    §ï¤é´Á´N      µLªk°õ¦æ
²M°ª ¯Ü®zªº°°¹¢

TOP

¥Î15¼Óªº¤èªk¥þ³¡§ï¦¨¤é´Á®æ¦¡¡C¸Õ¸Õ¡C
¸ê®ÆÀ³¬Ocopy¨Óªº¡A¬O¤å¦r¼Ò¦¡,¤é´Á¥Î¤â°Ê¿é¤J¬O¤é´Á®æ¦¡¡C­Y©È³Â·Ð¥i§âÁ`ªíAÄæ§ï¦¨¤å¦r¼Ò¦¡¤]¥i¥H¡C

TOP

k1=IF($J1="","",IF(INDIRECT($J1&"!"&CHAR(64+COLUMN(I1))&MATCH(TEXT(A$2,"yyyy/mm/dd"),INDIRECT($J1&"!A:A"),0))="ªÅ","ªÅ",""))

­×§ï¦¨³o¼Ë´N¥i¥H¤F
²×©ó§¹¦¨¤F
ÁÂÁª©¤j«ü¾É
²M°ª ¯Ü®zªº°°¹¢

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD