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

¦X¥I¨â­Ósheetªº¸ê®Æ

¦X¥I¨â­Ósheetªº¸ê®Æ

½Ð±Ð~~¦p¦ó§â¥I´Ú¤H¥DÀÉ»P¥I´Ú©ú²Ó¦X¨Ö¨ì«ü©w¤W¶Ç®æ¦¡¤¤
pay.rar (9.86 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2014-11-25 09:25 ½s¿è

¦^´_ 1# BETTYLO
´£¨Ñ¡u²Õ¦X¨ç¼Æ¡vª½Ä±¸Ñªk¡A½Ð°Ñ¦Ò¡I
1.¡u¤W¶ÇÀɮסv¤u§@ªí¤§Àx¦s®æD2¿é¤J°}¦C¤½¦¡ (¥HCtrl+Shift+Enter¤è¦¡¿é¤J)
=IFERROR(INDEX(¥I´Ú¤H¥DÀÉ!$D$2:$D$5,MATCH(0,COUNTIF($D$1:D1,¥I´Ú¤H¥DÀÉ!$D$2:$D$5),0)),"")
¦V¤U½Æ»s¤½¦¡
2.¿ï¨ú¡u¥I´Ú©ú²Ó¡v¤u§@ªíA1:I10½d³ò¡A«öCtrl+Shfit+F3¡A¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¡C
3.¡u¤W¶ÇÀɮסv¤u§@ªí¤§
Àx¦s®æK2¿é¤J¤@¯ë¤½¦¡=IF(COUNTIF(¦¬´Ú¤H¤á¦W,$D2)<(1+INT((COLUMN()-11)/8)),"",INDEX(³æ¾ÚÃþ§O,MATCH($D2,¦¬´Ú¤H¤á¦W,0)+INT((COLUMN()-11)/8)))
Àx¦s®æL2¿é¤J¤@¯ë¤½¦¡=IF(COUNTIF(¦¬´Ú¤H¤á¦W,$D2)<(1+INT((COLUMN()-11)/8)),"",INDEX(¥I´Ú¾ÌÃÒ¤é´Á,MATCH($D2,¦¬´Ú¤H¤á¦W,0)+INT((COLUMN()-11)/8)))
Àx¦s®æM2¿é¤J¤@¯ë¤½¦¡=IF(COUNTIF(¦¬´Ú¤H¤á¦W,$D2)<(1+INT((COLUMN()-11)/8)),"",INDEX(¥I´Ú¾ÌÃÒ¸¹½X,MATCH($D2,¦¬´Ú¤H¤á¦W,0)+INT((COLUMN()-11)/8)))
Àx¦s®æN2¿é¤J¤@¯ë¤½¦¡=IF(COUNTIF(¦¬´Ú¤H¤á¦W,$D2)<(1+INT((COLUMN()-11)/8)),"",INDEX(¥I´Ú¾ÌÃÒª÷ÃB,MATCH($D2,¦¬´Ú¤H¤á¦W,0)+INT((COLUMN()-11)/8)))
Àx¦s®æO2¿é¤J¤@¯ë¤½¦¡=IF(COUNTIF(¦¬´Ú¤H¤á¦W,$D2)<(1+INT((COLUMN()-11)/8)),"",INDEX(²{ª÷§é¦©,MATCH($D2,¦¬´Ú¤H¤á¦W,0)+INT((COLUMN()-11)/8)))
Àx¦s®æP2¿é¤J¤@¯ë¤½¦¡=IF(COUNTIF(¦¬´Ú¤H¤á¦W,$D2)<(1+INT((COLUMN()-11)/8)),"",INDEX(¹ê¥Iª÷ÃB,MATCH($D2,¦¬´Ú¤H¤á¦W,0)+INT((COLUMN()-11)/8)))
Àx¦s®æQ2¿é¤J¤@¯ë¤½¦¡=IF(COUNTIF(¦¬´Ú¤H¤á¦W,$D2)<(1+INT((COLUMN()-11)/8)),"",INDEX(½Õ¾ãÁ`ª÷ÃB,MATCH($D2,¦¬´Ú¤H¤á¦W,0)+INT((COLUMN()-11)/8)))
Àx¦s®æR2¿é¤J¤@¯ë¤½¦¡=IF(COUNTIF(¦¬´Ú¤H¤á¦W,$D2)<(1+INT((COLUMN()-11)/8)),"",INDEX(³Æµù,MATCH($D2,¦¬´Ú¤H¤á¦W,0)+INT((COLUMN()-11)/8))&"")
¦V¥k¡B¦V¤U½Æ»s¤½¦¡

TOP

¦^´_ 2# p212

§¹¦¨¤F~ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD