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

[µo°Ý] ¤£°÷¿n¤À, ¦ý«Ü·Q°Ý­ÓEXCEL·j´M¤Î½g±Æ°ÝÃD

[µo°Ý] ¤£°÷¿n¤À, ¦ý«Ü·Q°Ý­ÓEXCEL·j´M¤Î½g±Æ°ÝÃD

¥»©«³Ì«á¥Ñ tata211 ©ó 2017-1-24 16:55 ½s¿è



¦p¹Ï©Ò¥Ü­n¨D
½Ð°Ý­n¦p¦ó¹F¨ì©O?

®w¦s«~ºØ¬°¤U©Ô²M³æ
¦Ó¥B¬d¸ß¿é¤J¦ì¸m¥ç¬°¬Û¦Pªº¤U©Ô²M³æ
¿ï¦n«á¤U­±´N·|§â¤£¦P¤À­¶¤º(3­Ó¤À­¶)ªº¸ê®Æ¾ã¦æ¶K¦b¤U­±
³Ì¦nÁÙ¥i¥HÅã¥Ü¤@¦@¦h¤Ö¦æ

§Æ±æ¦³¤j¤jÀ°¦£¤U

http://blog.xuite.net/hcm19522/twblog/482154212
°Ñ¦Ò

TOP

¦^´_ 2# hcm19522


    ¤j¤j§A¦n
§Ú·Óºô­¶¤ºªºªí®æ­«°µ¤@­Ó§¹¥þ¤@¼Ëªº¸ê®Æ
¦ý¨ãÅéSHIFT+CTRL+ENTER¬O¦b¤°»ò¦a¤è«ö©O?
¦ÓA2:C10{=INDEX(Á`ªí!A:A,SMALL(IF(Á`ªí!$A$2:$A$15="ÂE®ü",ROW(A$2:A$15),4^8),ROW(A1)))&""³o­Ó¤½¦¡¤S¸Ó©ñ¦b¨º¨½©O?

TOP

¦^´_ 3# tata211

http://www.FunP.Net/804168

TOP

¦^´_ dpost&pid=97045&ptid=19201]4#[/url] hcm19522


    ¤j¤j³o­ÓÀɮשǩǪº
§Ú¦b¥ô·N¦ì¸m¿é¤J¥ô·N¸ê®Æ
ªí®æ¤ºªº¸ê®Æ¤]·|¸òµÛÅÜ°Ê.................

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-1-25 12:21 ½s¿è

¦^´_ 6# tata211

¼Æ¾Ú¥Î¶Ã¼Æ²£¥Í ,«öF9´N§ïÅÜ   ¥i§ï¦Û³]¸ê®Æ

TOP

ªí®æ2016-12-12.rar (11.36 KB)

¯à½Ð¤j¤j¥X¤âÀ°¦£¶Ü?
¹ê¨îªí®æ´N¦pªþ¥ó

TOP

­ì¨ÓÁÙ¦³¦Û°Ê²£¥Í¶Ã¼Æ³o¤@©Û..........­è¤~¬°¤F¤W­±¨º­Ó¨Ò¤lÀÉ®×..........¨C­Ó¼Æ¦r¤Î«~ºØ³£¬O¤@­Ó¤@­ÓºVÁä½Lªº.........

TOP

¥»©«³Ì«á¥Ñ tata211 ©ó 2017-1-25 15:31 ½s¿è

¦^´_ 4# hcm19522


¥Î¤F¤j¤jªº¤èªk
°Ñ¦Ò¤F¦n¤[§Ë¦¨³o¼Ë




ªí®æ2016-12-12 TEST 2.rar (13.05 KB)


¦ý½Ð°Ý¤é´Á¬O¤£¬O­n¥Î¤°»ò¤èªk¤~¯à¥Î©O?
¥t¥~¤À­¶¦WºÙ¤S¬O¦p¦ó¸òÀH¤½¦¡¶K¤W©O?

TOP



test 3 - ªí®æ2016-12-12.rar (14.72 KB)

ÁÙ®t¤@ÂIÂI´N¹F¦¨¥Øªº¤F :)
½Ð°Ý "ªí¤º¤é´Á" ¤Î "¤À­¶ªº¦WºÙ" ¨ì©³¬O­n¦p¦óCALL¹L¥h©O?

TOP

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