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

¸Ó¥ÎVLOOKÁÙ¬OCOUNTIF??

¦^´_ 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

¦^´_ 21# Hsieh

ÁÂÁÂHsieh¤jªº¸Ñ´b,¤]´N¬O»¡§Ú¦pªG­n¨C¤é¦A¦h¤@ºØ¯Z¦¸,´NÅÜ9Åo?
¦³¤@¤@ÂI¤F¸Ñ,¦A¦¸·PÁ§A.
¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 13# inhogold

13¼ÓÀÉ®×
ª½¦¡±Æ¯Zªí C2 ¤½¦¡
=LOOKUP("ùÜ",IF({1,0},"",LOOKUP(,0/(INDEX(¾î¦¡±Æ¯Zªí!A$3:L$6,,MATCH(RIGHT(LOOKUP("ùÜ",A$2:A2)),¾î¦¡±Æ¯Zªí!$2:$2,))=D2),¾î¦¡±Æ¯Zªí!E$3:E$6)))
¤U©Ô½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 23# ML089
ML089¤j,½Ð±Ð¤@¤U..."ùÜ"¬O¬Æ»ò·N«ä??
¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 24# inhogold

"ùÜ"¦ABIG5½X(63964)¤¤±µªñ³Ì¤j­È¡A±`»PLOOKUP·f°t¥Î¨Ó´M§ä½d³ò¤º³Ì«á¤@­Ó¤å¦r¶µ

¤]¦³¤H³ßÅw¥Î3°¦Às(ùÕ£y£«£¿)BIG5½X(63957)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 25# ML089
­ì¨ÓÁÙ¦³³o©Û,¤S¾Ç¨ì¤@©Û,ÁÂÁÂML089¤j
¨ºML089¤j,BIG5½X(63964)¤¤±µªñ³Ì¤j­Èªº·N«ä¬O.......¦C¼Æ³Ì¤j­Èªº·N«ä¶Ü?
¦A¦¸½Ð±Ð,·P®¦~~
¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 26# inhogold

¦^´_ 25# ML089
­ì¨ÓÁÙ¦³³o©Û,¤S¾Ç¨ì¤@©Û,ÁÂÁÂML089¤j
¨ºML089¤j,BIG5½X(63964)¤¤±µªñ³Ì¤j­Èªº·N«ä¬O.......¦C¼Æ³Ì¤j­Èªº·N«ä¶Ü?
¦A¦¸½Ð±Ð,·P®¦~~


»P¦C¼ÆµLÃö
³o¬OLOOKUPªº¨Ï¥Î¯S©Ê
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 27# ML089
ÁÂÁÂML089¤j,­ì¨Ó¬O³o¼Ë,§Ú»~·|¤F
·PÁ«ü±Ð
¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 21# Hsieh

±Æ¯Zªí .rar (11.08 KB)

Hsieh¤j,³oÃä«ö·Ó§Aµ¹ªº¨ç¼Æ....«á­±¬O¤£¦¨¤½¦¡ªº.....¥i¥H³Â·Ð¤@¤U¶Ü? @@"·P®¦!!
¸U¤V°ª¼Ó¥­¦a°_

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

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD