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

¦p¦ó§â¤£¦PªºxlsÀɮ׳sµ²¦b¤@°_¨Ï¥Î?

¦p¦ó§â¤£¦PªºxlsÀɮ׳sµ²¦b¤@°_¨Ï¥Î?

¯à§_¥Îexcel§â¤£¦PxlsÀÉ®×, ³sµ²¦b¥t¤@­Ó¤u§@ªí¸Ì¨Ó¬d¸ß¤Î¦C¦L¥X¤£¦P¸ê®Æªº³øªí.

¨Ò¦p¦³ÀÉ®×:-
1) ¨ÑÀ³°Ó¸ê®Æ (¥]¬A¨ì³f¤é´Á/»ù¿ú/ºØÃþµ¥);
2) «È¤á¸ê®Æ (¥]¬A­q³æ¤é´Á/°e¥æ¤é´Á/¶}³æ¤é´Á¤Î¶O¥Îµ¥);
3) ¥X/¤J³f°O¿ý;
4) ®w¦s°O¿ý;

³sµ²¨ì¤@­Ó·s¼W"Á`°ÈÀÉ®×".xls¸Ì, ¦P®É¥ÎÁ`°ÈÀɮ׬d¸ß¦b1),2),3),4)Àɮתº¸ê®Æ¤Î¨î¦¨¤@­ÓÁ`³øªí......ÁÂÁÂ!

½Ð´£¨Ñ¹Ï¤ù©ÎÀɮסA³o¼Ë¤~¦³¤H¥i¥HÀ°§U§A¡C
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

ÀÉ®×1) JOB ENTRY
ÀÉ®×2) NOTICE

¦bÀÉ®×2)¤¤¿é¤J¥H¤U¥yªk:-
=INDIRECT("[JOB ENTRY.xls]DATA!D"&MATCH($L$9,'[JOB ENTRY.xls]DATA'!$BB,0))
¦ýµ²ªG : #REF

TOP

¦^´_ 1# Leo1318

¨Ò¦p¦³ÀÉ®×:-
1) ¨ÑÀ³°Ó¸ê®Æ (¥]¬A¨ì³f¤é´Á/»ù¿ú/ºØÃþµ¥);
2) «È¤á¸ê®Æ (¥]¬A­q³æ¤é´Á/°e¥æ¤é´Á/¶}³æ¤é´Á¤Î¶O¥Îµ¥);
3) ¥X/¤J³f°O¿ý;
4) ®w¦s°O¿ý;

³sµ²¨ì¤@­Ó·s¼W"Á`°ÈÀÉ®×".xls¸Ì, ¦P®É¥ÎÁ`°ÈÀɮ׬d¸ß¦b1),2),3),4)Àɮתº¸ê®Æ¤Î¨î¦¨¤@­ÓÁ`³øªí......ÁÂÁÂ!


Àɮ׶¡¤§³sµ²¤èªk¡A
²³æªº¬O¾aID(½s¸¹)¡A¨Ò¦p¨ÑÀ³°Ó½s¸¹©Î«È¤á½s¸¹µ¥¹ïÀ³³sµ²¡A³o¨Ï¥ÎVLOOKUP¨ç¼Æ´N¯à§Ö³t¦³®Ä³sµ²¡C
½ÆÂøªº¬O¾a±ø¥ó§ä¥X³æµ§©Î¦hµ§¸ê®Æ¡C

¸ê®Æ®w¬ã¨s
1) ¨ÑÀ³°Ó¸ê®Æ (¥]¬A¨ì³f¤é´Á/»ù¿ú/ºØÃþµ¥); ³o§Ú¬Ý°_¨ÓÀ³¸Ó¬O¨Ñ®Æ¸ê®ÆÀÉ¡A¤£¬O¨ÑÀ³°Ó¸ê®Æ¡C
2) «È¤á¸ê®Æ (¥]¬A­q³æ¤é´Á/°e¥æ¤é´Á/¶}³æ¤é´Á¤Î¶O¥Îµ¥);³o§Ú¬Ý°_¨ÓÀ³¸Ó¬O­q³æ¸ê®ÆÀÉ¡A¤£¬O«È¤á¸ê®Æ¡C
¤@¯ë¨ÑÀ³°Ó¸ê®Æ¡B«È¤á¸ê®Æ³£¬O³æµ§¹ïÀ³¸ê®Æ¡A¨Ï¥ÎVLOOKUP´N¥i¥H¬d¸ß
¨Ñ®Æ¸ê®ÆÀÉ¡B­q³æ¸ê®ÆÀÉÄÝ©ó±ø¥ó¦hµ§¬d¸ß©Î²Î­p¡A

­Y¨S¦³´£¨Ñ©ú½Tªº¹ïÀ³Ãö«Y¹ê¦bÃø¥H»¡©ú

½Ð´£¨Ñ¸ê®ÆÀÉ(¼Ë¥»)¤Î»Ý­n³øªí®æ¦¡¡A³o¼Ë¤~¯à§@·~¡C
¥Ø«e¤ñ¸û¤£·|¨C¤Ñ¤W½×¾Â¡A¦ý¦³¹êÅéEXCELÀɤέn§¹¦¨ªº³øªí®æ¦¡¡A¨ä¥L¤H¤]¯àÀ°¦£¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

=INDIRECT("[JOB ENTRY.xls]DATA!D"&MATCH($L$9,'[JOB ENTRY.xls]DATA'!$B:$B,0))


º|¥h " ' "

=INDIRECT("'[JOB ENTRY.xls]DATA'!D"&MATCH($L$9,'[JOB ENTRY.xls]DATA'!$B:$B,0))

TOP

¦^´_ 4# ML089


    ÁÂÁª©¥Dªº¤Þ¾É:)

TOP

¦^´_ 5# JBY


    ÁÂJBY, ¯uªº¬O¥[¦^"', ´N¥i¥H³sµ²¹ïÀ³¥t¤@­ÓÀɮתº¸ê®Æ:victory: , ÁÂÁÂ:handshake !

TOP

¦^´_ 4# ML089

ÁÂÁª©¥D´£ÂI, §Ú¥ý¥hµý°µ¤@­ÓÀɮפW¶Ç¨Óµ¹ª©¥D¬Ý¬Ý.

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD