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

[µo°Ý] ¦U«ü©w¦C³Ì¤j­Èªº¦PÄæ¹ïÀ³­È¡C

[µo°Ý] ¦U«ü©w¦C³Ì¤j­Èªº¦PÄæ¹ïÀ³­È¡C


´ú¸Õªþ¥óÀÉ¡J ¦U«ü©w¦C³Ì¤j­Èªº¦PÄæ¹ïÀ³­È¡C.rar (4.94 KB)

³Æµù¡J
BZ3=($BO3¡J$BX3)ªº³Ì¤j¼Æ­È¡C
CA3=($BO10¡J$BX10)ªº³Ì¤j¼Æ­È¡C
CB3=($BO17¡J$BX17)ªº³Ì¤j¼Æ­È¡C
¨ä¾lCC3¡JCI3Ãþ±À¡C

»Ý¨D¡J
BZ4= BZ3³Ì¤j¼Æ­Èªº¤U1¦C¦PÄæÀx¦s®æ¼Æ­È¡A
¦pªG¤U1¦C¦PÄæÀx¦s®æ¦³2­Ó(§t)¥H¤Wªº¼Æ­È¡A³£¨Ì§Ç©¹¤U¶ñ¤J~¹w©Ô¨ìBZ13(µL¶ñ¤J­ÈªºÀx¦s®æ¡AÅã¥ÜªÅ¥Õ)¡C

CA4= CA3³Ì¤j¼Æ­Èªº¤U1¦C¦PÄæÀx¦s®æ¼Æ­È¡A
¦pªG¤U1¦C¦PÄæÀx¦s®æ¦³2­Ó(§t)¥H¤Wªº¼Æ­È¡A³£¨Ì§Ç©¹¤U¶ñ¤J~¹w©Ô¨ìCA13(µL¶ñ¤J­ÈªºÀx¦s®æ¡AÅã¥ÜªÅ¥Õ)¡C

CB4= CB3³Ì¤j¼Æ­Èªº¤U1¦C¦PÄæÀx¦s®æ¼Æ­È¡A
¦pªG¤U1¦C¦PÄæÀx¦s®æ¦³2­Ó(§t)¥H¤Wªº¼Æ­È¡A³£¨Ì§Ç©¹¤U¶ñ¤J~¹w©Ô¨ìCB13(µL¶ñ¤J­ÈªºÀx¦s®æ¡AÅã¥ÜªÅ¥Õ)¡C

¨ä¾lCC4¡JCI13Ãþ±À¡C

½Ð°Ý¡JBZ4¡JCI13»Ý¨DªºExcel 2003ª©ªº¨ç¼Æ¤½¦¡¡H
·Ð½Ð¦U¦ì¤j¤jÀ°¦£¡IÁÂÁ¡I

BZ4//°}¦C¤½¦¡:
=RIGHT(SUBSTITUTE(SMALL(--TEXT(0&MID(IF(INDEX($BO:$BX,COLUMN(A$1)*7-4,)=BZ$3,INDEX($BO:$BX,COLUMN(A$1)*7-3,),0),{1;4;7;10;13},2),"[=]!9!e9;"&COLUMN($A:$J)/1%),ROW(A1)),--"9e9",),2)

TOP

¦^´_ 2# ­ã´£³¡ªL
­ã´£ª©¥D :
´ú¸Õ§¹¥þOK¤F!
ÁÂÁ±zªº¼ö¤ß«ü¾É©MÀ°¦£!
·P®¦

TOP

¦^´_ 2# ­ã´£³¡ªL

­ã´£ª©¥D :
¤£¦n·N«ä ¡A¥i§_½Ð±Ð±z :
±N¦¸¤j!BZ4§ï¬°²Ä5¦Cªº¤U1¦C(²Ä6¦C¦¸¤j)ªº¦PÄæ¹ïÀ³­Èªº¨ç¼Æ¤½¦¡?
¦³¸Õ±N2¼Ó»Õ¤Uªº³Ì¤j!BZ4¤½¦¡§ï¬°
=RIGHT(SUBSTITUTE(SMALL(--TEXT(0&MID(IF(INDEX($BO:$BX,COLUMN(A$1)*7-6,)=BZ$3,INDEX($BO:$BX,COLUMN(A$1)*7-5,),0),{1;4;7;10;13},2),"[=]!9!e9;"&COLUMN($A:$J)/1%),ROW(A1)),--"9e9",),2)
¦ý´ú¸Õ«á¡A¤£¥¿½T^^"
±N¤T¤j!BZ4§ï¬°²Ä7¦Cªº¤U1¦C(²Ä8¦C¤T¤j)ªº¦PÄæ¹ïÀ³­Èªº¨ç¼Æ¤½¦¡?
ÁÂÁ±z^^

´ú¸ÕÀÉ : [attach]31583[/attach]
½d¨Òªº¦U¤u§@ªí³£¬°¼ÒÀÀ¤º®e¡C

TOP

¦^´_ 4# papaya
¸É´ú¸ÕÀÉ :   ¦U«ü©w¦C«e3¤j­Èªº¦PÄæ¹ïÀ³­È¡C.rar (7.46 KB)

TOP

¦^´_ 5# papaya

¦¸¤j:
=RIGHT(SUBSTITUTE(SMALL(--TEXT(0&MID(IF(INDEX($BO:$BX,COLUMN(A$1)*7-2,)=BZ$3,INDEX($BO:$BX,COLUMN(A$1)*7-1,),0),{1;4;7;10;13},2),"[=]!9!e9;"&COLUMN($A:$J)/1%),ROW(A1)),--"9e9",),2)

¤T¤j:
=RIGHT(SUBSTITUTE(SMALL(--TEXT(0&MID(IF(INDEX($BO:$BX,COLUMN(A$1)*7,)=BZ$3,INDEX($BO:$BX,COLUMN(A$1)*7+1,),0),{1;4;7;10;13},2),"[=]!9!e9;"&COLUMN($A:$J)/1%),ROW(A1)),--"9e9",),2)

TOP

ª©¥D : ±z¦n!
·PÁ±zªº¼ö¤ßÀ°¦£©M«ü¾É!
¨S¦³·Q¨ì¬O+2¡A¤£¬O-2^^"

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD