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

¸Ó¥ÎVLOOKÁÙ¬OCOUNTIF??

¸Ó¥ÎVLOOKÁÙ¬OCOUNTIF??

[attach]18825[/attach]

½Ð°Ý¤@¤U¡A¸Ó¦p¦ó¦b¥ªÃä¾î¦¡±Æ¯Zªí¿é¤J¥¿¯Z°Æ¯Z±¡ªp¤U¡A
¦b¥kÃ䪽¦¡¥¿¯Z°Æ¯Z·Q¹ïÀ³¯Z¦¸¤U·|¦Û°ÊÅã¥Ü¤H¦W?
³Â·Ð¦U¦ì¤j¤j¤F!!@@"
¸U¤V°ª¼Ó¥­¦a°_

¦^´_ 32# Hsieh

ÁÂÁÂHsieh¤jªº«ü¾É,§Ú¦b¸Õ¸Õ~~·PÁ§A
¸U¤V°ª¼Ó¥­¦a°_

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

¦^´_ 30# Hsieh

ÁÂÁÂHsieh¤jªº«ü¾É,¥i¥H½Ð°Ý¤@¤U¨º¼Æ¦r40¬O¬Æ»ò·N«ä§r???
¦]¬°¤½¥q¥Îªº¬O«Ê³¬¦¡ºô¸ô.....§Úµe¸¬Äªªº¿é¤J¶i¥h....¥i¬O¥LÅã¥Ü #N/A ÂIExcel»¡©ú¶i¥h¬Ý,¥i¯àªº­ì¦]¦³«Ü¦hºØ...
§Ú¬O¤£¬O¤Ö°µ¤F¬Æ»ò¨BÆJ???
¦A¦¸³Â·Ð¤F.....·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

¦^´_ 21# Hsieh

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

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

TOP

¦^´_ 27# ML089
ÁÂÁÂML089¤j,­ì¨Ó¬O³o¼Ë,§Ú»~·|¤F
·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

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

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD