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

[µo°Ý] µæ³¾°Ýexcel°ÝÃD

[µo°Ý] µæ³¾°Ýexcel°ÝÃD

§Ú­Ìªº½u¤W²£«~¥ÎexcelÀx¦s¡A¬ù1¸U±ø¡A­Y§Ú§Æ±æÀH¾÷ªº©â¨ú·í¤¤ªº50±ø¡AµM«á¦s¦¨¤@­Ó·sªºªí®æÀ³¸Ó«ç¼Ë°µ¡H

¤@¸Uµ§¸ê®Æ³]¯Á¤Þ(³]¦b²Ä¤@Äæ)¡A¦b·sªí®æ²Ä¤@Äæ©ñ=RANDBETWEEN(1,10000)©¹¤U©Ô50®æ
·|²£¥Í50µ§1¨ì1¸UªºÀH¾÷¾ã¼Æ¡A¦A¥Îvlookup§â¬Û¹ïÀ³¸ê®Æ±a¥X¨Ó

TOP

¦^´_ 2# ¹q·xÄl


    ¤£©ú¥Õ¤°»ò¬Ovlookup? ¥i§_¸Ô²Ó¤@ÂI¡AÁÂÁÂ

TOP

¦^´_ 3# keeon

¥i°Ñ¦Ò @@~
http://support.microsoft.com/kb/181213/zh-tw
and
http://imil.au.edu.tw/~hsichcl/Excel/Unit3/excel3_6_4_2.htm

TOP

¦^´_ 3# keeon

°Ñ¦Ò½d¨ÒÀÉ
http://www.FunP.Net/662903

TOP

¦^´_ 1# keeon

123.png
2015-1-30 00:29


Àɮצs©ñ¦bhttp://www.FunP.Net/662903

TOP

¦^´_ 6# ¹q·xÄl

ÁÂÁ¸ѵª¡A¦ý¬O¤´Â¤£©ú¥Õ¡A¥i§_§Úµ¹§A§Úªºªí®æ¡AÀ°¦£¬Ý¬Ý«ç¼Ë°µ¡H§Úªº¹q¶l¬O[email protected]
·P¿E¸U¤À

TOP

¦^´_ 7# keeon


    ©ñ¦b³o¸Ì°Úhttp://www.FunP.Net/662903
§A§â¨ì½Æ»s¨ìºô§}¦C´N¥i¥H¤U¸ü¤F
³o¬O¶³ºÝµwºÐ

TOP

¦^´_ 7# keeon


§A¦³¨S¦³¬ÝÀÉhttp://www.FunP.Net/662903¡HÁÙ¬O¬Ý¤F¤§«áÁÙ¤£©ú¥Õ¡H¡H
­º¥ý§A´N¦b¤@¸Uµ§¸ê®Æ³]¯Á¤Þ(²£«~½s¸¹1¨ì1¸U)
¦A¨Ó¦b¤@­Ó·s¤u§@­¶¥Î=RANDBETWEEN(1,10000)©¹¤U©Ô50®æ¡A³]50µ§ÀH¾÷¶Ã¼Æ
456.png
2015-2-1 15:35

¦b¤@¸Uµ§¸ê®Æ³Ì«e­±´¡¤J¤@Äæ©ñA2=IF(ISERROR(MATCH(B2,·sªí®æ!$A$2:$A$51,0)),"no","ok")
123.png
2015-2-1 15:35

¦b¥Î¿z¿ï¥XAÄæ"ok"ªº¸ê®Æ¡A½Æ»s¤u§@­¶¡A¶K¨ì·s¤u§@­¶¡A³o´N¬O50µ§ÀH¾÷¸ê®Æ
789.png
2015-2-1 15:35

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD