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

¸Ó¥ÎVLOOKÁÙ¬OCOUNTIF??

¦^´_ 3# inhogold

H1¤½¦¡
=INDEX($A$2:$A$5,MATCH(G1,INDEX($B$2:$D$5,,MATCH(OFFSET(F1,-MOD(ROW()-1,4),),$B$1:$D$1,0)),0),)
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 13# inhogold
¨âªí¯Z§O¤£¦P?
¬°¦óª½¦¡ªí®æ¦³¥¿¯Z1¡B°Æ¯Z1¡B±ß¯Z1¡B¦­¯Z1?
C2=INDEX(¾î¦¡±Æ¯Zªí!$E:$E,MATCH(ª½¦¡±Æ¯Zªí!$D2,INDEX(¾î¦¡±Æ¯Zªí!$A:$L,,MATCH(OFFSET($B2,-MOD(ROW()-2,8),),¾î¦¡±Æ¯Zªí!$1:$1,0)),0),)
¥¼¥X²{¯Z§O·|¥X²{¿ù»~
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 18# inhogold
MATCH(OFFSET($B2,-MOD(ROW()-2,8),),¾î¦¡±Æ¯Zªí!$1:$1,0)
¬°¤F¦b¾î¦¡ªí®æ§ä¨ì»PB2¬Û¦P­Èªº¦ì¸m¡A¨Ï¥ÎMATCH¨ç¼Æ
¬õ¦r³¡¤À¬°MATCHªº²Ä¤@­Ó°Ñ¼Æ
¦]¬°§ABÄ檺½s²Õ¼Æ¦r¬O¨C8®æ¤~¨Ï¥Î¤@­Ó¼Æ­È
©Ò¥H·í¤½¦¡¤U©Ô®É­n±o¨ì¤½¦¡¦ì¸m¬Û¹ïÀ³ªº¼Æ­È
´N¬O¥Ñ¸Ó¦C¦V¤W¦ì²¾¶q¨Ó¨ú±o
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 20# inhogold

MOD(ROW()-2,8)
´N¬O¦C¦ì´î2°£¥H8ªº¾l¼Æ
¦]¬°¬O±q²Ä2¦C¶}©l¡A¦C¦ì§Y¬°2¡A3¡A4¡A5¡A6¡A7¡A8¡A9¡A10.....
´î2¥H«á¦¨¬°0¡A1¡A2¡A3¡A4¡A5¡A6¡A7¡A8.....
°£¥H8ªº¾l¼Æ´N¬°0¡A1¡A2¡A3¡A4¡A5¡A6¡A7¡A0¡A1¡A2.....
0~7ªº´`Àô
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 29# inhogold
¤é´Áªº´M§ä§ï¥ÎLOOKUP§ä¨ì¹ïÀ³¤é´Á¡A³o¼Ë´N¤£»Ý­pºâ¦C¼Æ¥X¿ù
ª½¦¡±Æ¯ZªíC2=INDEX(¾î¦¡±Æ¯Zªí!$E:$E,MATCH(D2,INDEX(¾î¦¡±Æ¯Zªí!$A$1:$AJ$57,,MATCH(LOOKUP(40,B$2:B2),¾î¦¡±Æ¯Zªí!$1:$1,0)),0),)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2014-9-25 10:48 ½s¿è

¦^´_ 31# inhogold

LOOKUP¨ç¼Æ¯S©Ê
­n´M§ä³Ì«á¤@­Ó¼Æ­È¡A´N¨Ï¥Î¼Æ¦C¤¤³Ì¤j­È¥H¤Wªº­È¨Ó°µ·j´M¥Ø¼Ð
¦]¬°¤é´Á³Ì¤j¬O31¥u­n¬O¶W¹L31ªº¼Æ­È§@·j´M¥Ø¼Ð´N¥i¥H¡A¨Ã«D¤@©w­n¥Î40
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD