¥»©«³Ì«á¥Ñ stephenlee ©ó 2020-7-18 12:55 ½s¿è
§Ú¦³ 2Ó¤u§@ªí,¤@Ó¬O¸ê®Æ¨Ó·½, ¥t¤@Ó¬On±q ¸ê®Æ¨Ó·½¤¤,
±N¸ê®Æ½Æ»s¹L¥hªº¤u§@ªí¡C
¨Ò¦p¦b100Ä椤½Æ»s¬ù10Äæ, ¦Ó¨C¤@¦¸ §Ú³£¬O¦Û¤v¨C¤@¦æ ±q ²Ä¤G¦C½Æ»s¦Ü§À,¦A¨C¤@¦æ¶K¤W¦Ü ¥Ø¼Ð¤u§@ªí,³o¼Ë¤U¨Ó·|«Üªá®É¶¡¡C
¦P®É¦]¬° ¸ê®Æ¨Ó·½ªºÄæ¦ì±Æ¦C¥¼¥²¬O¨C¦¸¤@¼Ë, ¤µ¤Ñ¦b AÄ檺¸ê®Æ,©ú¤Ñ¥i¯à¦bCÄæ, ¦ý¬O Äæ¦ìªº¦WºÙ¬O©T©w¤£Åܪº¡C
§Ú·Q¥ÎVBA ¥ý´M§ä ¸ê®Æ¨Ó·½ªº©T©wÄæ¦ì¦WºÙ, ¦A¥Ñ¸ÓÄæ¦ìªº²Ä¤G¦C ¥´ª½½Æ»s¦Ü¥Ø¼Ð¤u§@ªíªº©T©wÄæ¦ìªº²Ä¤G¦Ü§À¦C¡C
¨Ò¦p¤u§@ªí1,¦³«Ü¦h¸ê®Æ, ¦ý§Ú¥u»Ý 4ÓÄæ¦ì¦WºÙªº¸ê®Æ, ±N¸ê®Æ½Æ»s¦Ü¤u§@ªí2 ¤º¡C
·N«ä¬O§ä´M ¸ê®Æ¨Ó·½ªºÄæ¦ì, ¦A°t¥Ø¼Ð¶K¤W¤u§@ªí¤WªºÄæ¦ì¡C
¦]¬°ÁÙ¦³¨ä¥L¤u§@ªí¬O¶W©ó100Ä檺, ¦P®Én©â¨úªº¸ê®Æ,¤]«Ü¦h, ¦p¦ó¥ÎVBA °µ¥H¤W°Ê§@,ÁÂÁ¡C
¸ê®Æ¨Ó·½ªº¬¡¶Ã¯¦WºÙ ¤£¬O©T©wªº, ¦Ó¬¡¶Ã¯ªº¤u§@ªí¦W¬° Raw Data ¬O©T©wªº
¶K¨ì ¥t¥~¤@Ó¬¡¶Ã¯¦W¬°Data.xlsm¤ºªº ¦WºÙ¤u§@ªí1 ¤º
question 2.zip (9.23 KB)
|