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

EXCELªO

EXCELªO

§Ú·Q°ÝEXCELªº°ÝÃD, ¦ý¤£¯à°Ý, ¤S­n§Ú®³¤À¤~¥i¥H°Ý
¦ý§Ú¨S¦³§Oªº§xÃø, ´N¥u¬O·Q¸ß°ÝEXCEL¦³Ãöªº°ÝÃD
¨º§Ú¥i¥H«ç¼Ë°µ
µn¤J50¤Ñ¤~¥i¥H°Ý?!
ÁÙ¬O§Ú¦b³o°Ý´N¦n¤F

°ÝÃD¦p¤U:
§Ú·Q¦b"Á`"ªºA1:A8¿é¤J¤F¤@°ï¸ê®Æ, ¦p¹Ï"Á`"
¦b"1¤ë"ªº¨º±i¤u§@¯È§Ú¸Ó¿é¤J¬Æ»ò¤½¦¡¤~·|¦³"1¤ë®ÄªG"ªº®ÄªG©O
¦b1¤ë¨º±i¤u±i¯È®Ç¦³¤@°ï°Ñ¦Ò¸ê®Æ
§Ú¤S¥i¥H«ç¼Ë¥Î©O?

1¤ë.png (38.49 KB)

1¤ë.png

1¤ë®ÄªG.png (39.52 KB)

1¤ë®ÄªG.png

Á`.png (36.75 KB)

Á`.png

«ç¼Ë¤~¥i¥H¦Û°Ê¤À¿ì©M¦Û°Ê¿ï¾Ü©ÊŪ¨ú©O?

TOP

³sÄòµn¤J50¤Ñ¨ú±o¿n¤À§Y¥i¦bEXCEL°Ïµo©«
½Ð¨Ì½×¾Â³W©w¦æ¤§¡AÄé¤ô©«¤@«ß§R°£
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

TOP

¦^´_ 2# °ÝÃD¯«µ£

1¤ë
  =IF(AND(INDEX(Á`!A:A,ROW())<>"",MONTH(INDEX(Á`!A:A,ROW()))=1),INDEX(Á`!A:A,ROW()),"")
2¤ë
=IF(AND(INDEX(Á`!A:A,ROW())<>"",MONTH(INDEX(Á`!A:A,ROW()))=2),INDEX(Á`!A:A,ROW()),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  °ÝÃD¯«µ£

1¤ë
  =IF(AND(INDEX(Á`!A:A,ROW())"",MONTH(INDEX(Á`!A:A,ROW()))=1),INDEX(Á`!A:A,R ...
Hsieh µoªí©ó 2019-2-12 16:20



    ·PÁ¦^´_

TOP

³sÄòµn¤J50¤Ñ¨ú±o¿n¤À§Y¥i¦bEXCEL°Ïµo©«
½Ð¨Ì½×¾Â³W©w¦æ¤§¡AÄé¤ô©«¤@«ß§R°£
¤p»x µoªí©ó 2019-2-12 15:57



    ¦pªG§Ú¥i¥Hµ¥50¤Ñ, §Ú´N¤£·|«æµÛ¤W¤@¨Ç½×¾Â°Ý, ­­¤@¨Ç¦³ªº¨Sªº, ªýê¯u¤ß·Q¨D§Uªº¤HÁÙ¬O¥u·Q¤H®aÃÙ§U§A?
¤£­nµ¹§Ú»¡¬ï´NÃöPOST, ¯u¤ßÀ°¤HÁÙ¬O¬°¿ú ¤@²´¬Ý¨ì

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD