Excel word ppt officeʹÓü¼ÇÉ´óÈ«(DOC¸ñʽ)-µÚ105ÕÂ

°´¼üÅÌÉÏ·½Ïò¼ü ¡û »ò ¡ú ¿É¿ìËÙÉÏÏ·­Ò³£¬°´¼üÅÌÉ쵀 Enter ¼ü¿É»Øµ½±¾ÊéĿ¼ҳ£¬°´¼üÅÌÉÏ·½Ïò¼ü ¡ü ¿É»Øµ½±¾Ò³¶¥²¿£¡
¡ª¡ª¡ª¡ªÎ´ÔĶÁÍꣿ¼ÓÈëÊéÇ©ÒѱãÏ´μÌÐøÔĶÁ£¡



¡¡¡¡¡¡¡¡ÁС¡£¨×ֶΣ©ÒÔR1£»R2£»R3£»R4£»R5¡£¡£¡£¡£¡£¡£¡¡¡¡

¡¡¡¡¡¡¡¡ÐС¡£¨¼Ç¼£©ÒÔC1£»C2£»C3£»C4£»C5¡£¡£¡£¡£¡£¡£¡¡¡¡

¡¡¡¡¡¡¡¡µÚÒ»ÁеÚÒ»Ðеĵ¥Ôª¸ñΪ¡¡R1C1¡¡¡¡

¡¡¡¡¡¡¡¡£¨¶þ£©Çë²ÎÔÄ¡¡INDIRECT¡¡º¯ÊýµÄ°ïÖú˵Ã÷£¡£¡£¡¡¡¡¡

¡¡¡¡¡¡¡¡¹«Ê½£º¡¡¡¡

¡¡¡¡¡¡¡¡=INDIRECT£¨¡¨r¡¨&INT£¨£¨ROW£¨£©£«1£©/2£©&¡¡¡¨c¡¨&MOD£¨ROW£¨£©£«1£»2£©£«1£»0£©¡¡¡¡

¡¡¡¡¡¡¡¡µÈͬÓÚ£º¡¡¡¡

¡¡¡¡¡¡¡¡=INDIRECT£¨¡¨r¡¨&INT£¨£¨ROW£¨£©£«1£©/2£©&¡¡¡¨c¡¨&MOD£¨ROW£¨£©£«1£»2£©£«1£»FALSE£©¡¡¡¡

¡¡¡¡¡¡¡¡£¨Èý£©¹¤¾ß¡­¡­¡·Ñ¡Ïî¡­¡­¡·³£¹æ¡­¡­¡·ÉèÖã»»¹¿ÉÑ¡È¡¡¡R1C1¡¡ÒýÓÃÑùʽ¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Ã¿´ÎÇå³ýÊý¾ÝʱÄÜ·ñ×÷µ½Ìø¹ýÒþ²ØµÄµ¥Ôª¸ñ¡¡¡¡



½â´ð£ºF5¡­¡­¡­¡­¶¨Î»Ìõ¼þ¡­¡­¡­¡­³£Á¿¡­¡­¡­¡­È·¶¨¡­¡­¡­¡­Del¡¡¡¡

»ò£ºF5£­£¾¶¨Î»Ìõ¼þ¡­¡·¿É¼ûµ¥Ôª¸ñ¡­¡·È·¶¨¡­¡·DEL¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡Ò²¾ÍÊǵ¥»÷¡¡Sheet2¡¡Ê±£¬ÔÚ¡¡Sheet1¡¡µÄA¡¡ÁеÄ×îºóÒ»¸ö¼Ç¼µÄÏÂÒ»ÐÐ×Ô¶¯ÌîÉÏ¡°End¡±¡¡¡¡



ÔÚ¡¡sheet2£º¡¡¡¡

Private¡¡Sub¡¡Worksheet_Activate£¨£©¡¡¡¡

dim¡¡i¡¡as¡¡integer¡¡¡¡

i¡¡=¡¡Sheets£¨¡¨Sheet1¡¨£©¡£Cells£¨1£»¡¡1£©¡£CurrentRegion¡£Rows¡£Count¡¡¡¡

Sheets£¨¡¨Sheet1¡¨£©¡£Cells£¨i¡¡£«¡¡1£»¡¡1£©¡¡=¡¡¡¨End¡¨¡¡¡¡¡¡

End¡¡Sub¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Óú¯Êý½«ÊäÈëµÄÔ·Ýת»»ÎªÕâ¸öÔÂËù°üº¬µÄÌìÊý¡¡¡¡



¼ÙÉè¡¡A1¡¡µ¥Ôª¸ñΪÔ·ݣº¡¡¡¡

£½TEXT£¨£¨DATE£¨YEAR£¨NOW£¨£©£©£»A1£«1£»1£©¡­1£©£»¡¨d¡¨£©¡¡¡¡

»ò£º=DAY£¨DATE£¨YEAR£¨NOW£¨£©£©£»A1£«1£»0£©£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡½éÉܾ­Ñ飺¾Í¡¡SUM¡¡º¯ÊýÀ´½²£»ÒÔ϶¯Ì¬µØÖ·¿ÉÐС¡¡¡



1¡£SUM£¨A1£ºA2£©£»SUM£¨A1£ºA2£©¡¡¡¡

2¡£B2=¡¨A9¡¨£»¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡348¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡349¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡



SUM£¨INDIRECT£¨¡¨a1£º¡¨&B2£©£©¡¡¡¡

3¡£B1=¡¨A1¡¨£»B2=¡¨A9¡¨¡¡¡¡

SUM£¨INDIRECT£¨B1&¡¨£º¡¨&B2£©£©¡¡¡¡

4¡£B1=¡¨A1£ºA9¡¨¡¡¡¡

SUM£¨INDIRECT£¨B1£©£©¡¡¡¡

5¡£SUM£¨INDIRECT£¨¡¨A1£º¡¨&¡¨A¡¨&ROW£¨£©¡­1£©£©¡¡¡¡

6¡£SUM£¨INDIRECT£¨¡¨A1£º¡¨&ADDRESS£¨ROW£¨£©¡­1£»COLUMN£¨£©£©£©£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÔÚ¡¡EXCEL¡¡ÖÐÈçºÎͳ¼Æ×ÖÊý¡¡¡¡



Óãû=SUM£¨LEN£¨·¶Î§£©£©£ýÊÔÊÔ¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÈçºÎ×Ô¶¯Ìî³äÄÚÈÝ¡¡¡¡



A1£ºA20¡¡ÊDZàºÅ£¬B1£ºB20¡¡ÊÇÐÕÃû£¬C1£ºC20¡¡ÊÇÐԱ𣬵±ÎÒÔÚ¡¡A21¡¡µ¥Ôª¸ñÊäÈë¡¡A1£ºA20¡¡·¶Î§ÄÚ¡¡

µÄÈÎÒâÒ»¸ö±àºÅʱ£¬B21¡¡³öÏÖ¶ÔÓ¦µÄÐÕÃû£¬C21¡¡³öÏÖ¶ÔÓ¦µÄÐԱ𡣸ÃÈçºÎ×ö£¬Çë°ïæ¡£¡¡¡¡

½â´ð£ºB21¡¡µ¥Ôª¸ñ¹«Ê½¡°=IF£¨A21=0£»¡¨¡¨£»VLOOKUP£¨A21£»A1£ºC20£»2£»FALSE£©£©¡±£»C21¡¡µ¥Ôª¸ñ¹«Ê½¡¡

¡¡¡°=IF£¨A21=0£»¡¨¡¨£»VLOOKUP£¨A21£»A1£ºC20£»3£»FALSE£©£©¡±Õâ¸ö¹«Ê½Ò²ÊÊÓÃÓÚA¡¡ÁбàºÅ²»ÅÅÐòµÄÇé¿ö£¬¡¡

Èç¹ûÉýÐòµÄ»°»á¸ü¼òµ¥Ò»µã¡£¡¡¡¡

ÎÊ£ºÒÔÉϹ«Ê½ÖеÄ'false'ÓÐʲôÓã¿ÄÜ·ñÊ¡ÂÔ£¿¡¡¡¡

´ð£ºfalse¡¡²ÎÊýÖ÷ÒªÊÇÓÃËüÒÔºóÔÚ¡¡A¡¡ÁÐÖеÄÊý¾Ý¿ÉÒÔ²»ÊÇÉýÐòÅÅÁС£²»È»Èç¹û¡¡A¡¡Áв»ÊÇÉýÐòÅÅ¡¡

ÁУ¬¹«Ê½»á³ö´íµÄ¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¹¤×÷±íµÄ±êÇ©µÄ×ÖÌåºÍ´óС¿ÉÒÔ¸ü¸ÄÂð¡¡¡¡



´ð£ºÔÚ×ÀÃæÉϵãÓÒ¼ü©¤ÄÚÈÝ©¤Íâ¹Û£¬Ïà¹ØµÄÉ趨¶¼Ôڴ˸ü¸Ä¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡×Ô¶¨Òå¸ñʽµÄÌå»á¡¡¡¡



ÔÚ¡¡format¡¡cell¡¡µÄʱºò£¬Ñ¡ÁË¡¡custom¡¡ºóÔÚ¸ñ×ÓÀïÊäÈëÄãÏëÒªµÄλÊý£¬²»±äµÄ²¿·Ö¾ÍÕÕ×Å´ò½ø¡¡

È¥£¬»á±äµÃ²¿·Ö´ò¡¡0¡¡¾ÍºÃÁË£¬£¨Óá¡0¡¡Õ¼Î»£©¡£¡¡¡¡¡¡

ÀýÈ磺ÄãÒª´òµÄÊý×ÖÊÇ¡¡00715834123456£¬ºó¡¡6¡¡Î»ÊDz»¶¨µÄ£¬ÄÇÄãÒª´òÔÚ¸ñ×ÓÀïÃæ¡¡

00715834000000¡£ÕâÑùÈç¹ûÄãÊäÈë×îºó¡¡3¡¡Î»ÊÇ¡¡012£¬ÄÇô»áÏÔʾ³ö¡¡00715834000012£»Èç¹ûÄãÊä¡¡

Èë¡¡54321£¬ÄÇô»áÏÔʾ³ö¡¡00715834054321¡£¡¡¡¡¡¡

Èç¹ûÄã»á±äµÃ²¿·ÖÊÇÔÚÊý×ÖµÄÖм䣬±ÈÈçÎҵġ¡item#»áÊÇ¡¡9690000001¡­0000002£¬ºóÃæµÄ¡¡

¡­0000002¡¡ÊDz»±äµÄ£¬ÄÇÎҾͿÉÒÔÉèÖÃ×Ô¶¨Òå¸ñʽΪ¡¡9690000000¡¨¡­0000002¡¨£»ÕâÑùµ±ÎÒ¼üÈë¡¡502¡¡

µÄʱºò¾Í»áÏÔʾ¡¡9690000502¡­0000002¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÔÙ´ÎÏÔʾ³ö±»Òþ²ØµôÁ˵ÄÐУ¨µÚ¡¡1¡¡ÐУ©¡¡¡¡



1£º¡¡¡¡Ñ¡ÖÐÒþ²ØµÄÉÏ¡¢ÏÂÐУ¬ÓÒ»÷Êó±ê£¬Ñ¡¡°È¡ÏûÒþ²Ø¡±¡¡£¨×÷Õß×¢£º´Ë·¨¿ÉÐУ©¡¡¡¡¡¡

2£ºCtrl£«A¡­¡­¡­¡­¡­¸ñʽ¡­¡­¡­¡­¡­ÐС­¡­¡­¡­¡­È¡ÏûÒþ²Ø£¨¿ÉÒÔ£¬Äܹ»Ò»´ÎÏÔʾËùÓÐÒþ²ØµÄÐлòÁУ©¡¡¡¡

3£ºÁíÒ»·¨£¨¹¤×÷±í´¦ÓÚδ±£»¤×´Ì¬£©£º¼ÙÈç¡¡A1¡¡±»Òþ²ØÁËÔÚÃû³Æ¿òÖмüÈëA1£»»Ø³µ°´¡¡¡¡

Ctrl£«Shift£«0¡¡»ò¡¡Ctrl£«Shift£«9£¨Ö»ÏÔʾѡ¶¨µÄÒþ²ØÁлòÐУ©¡¡¡¡

4£º¹â±êÒƵ½Ðкš¡4¡¡Éϲ¿±ä³É¡¡ÉÏϼýÍ·×´£»¡¡°´×¡ÁË£»¡¡ÍÏÒ²Òª°ÑËüÍϳöÀ´£¡£¨Âý£¬²»ºÃ²Ù×÷£©¡¡¡¡

5£ºÑ¡ÔñÕû¸ö¹¤×÷±í£¨µã»÷×óÉϽǣ©£¬È»ºóÔÙÑ¡Ôñ²Ëµ¥ÖеÄÐУ¬Ñ¡Ôñ×îÊʺϵÄÐиߣ¬È»ºó¾Í¡¡OK£¡£»¡¡

ͬÑù¿ÉÒÔ°ÑÒþ²ØµÄÁÐÏÔʾ³öÀ´¡££¨Õâ¸ö°ì·¨×îºÃ£¬Äܹ»Ò»´ÎÏÔʾËùÓÐÒþ²ØµÄÐлòÁУ©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡349¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡350¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÈçºÎ¶¨ÒåÓÐЧÊý×Ö¡¡¡¡



¡¡¡¡¡¡¡¡Àý£ºÈ¡Á½Î»ÓÐЧÊýÊÇ´ÓµÚÒ»¸ö²»ÊÇÁãµÄÊý×ÖÆð£¬È¡Á½Î»¡£0¡£0023666¡¡È¡Á½Î»ÓÐЧÊýÊÇ¡¡



0¡£0023¡¡¡£0¡£2366¡¡È¡Á½Î»ÓÐЧÊýÊÇ¡¡0¡£23¡£¡¡¡¡



¡¡¡¡¡¡¡¡½â´ð£ºÓú¯Êý¿ÉÈçÏ£º¡¡=FLOOR£¨A1£»¡¡SIGN£¨A1£©*10^£¨INT£¨LOG£¨ABS£¨A1£©£©£©¡­1£©£©£»¡¡£«/СÊýÓС¡



Ч£»0¡¡ÎÞЧ¡£¡¡¡¡



¡¡¡¡¡¡¡¡ÆäËüÐÎʽµÄÊý¾Ý£»¡¡×ÔÐÐÀ©Õ¹¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡sheet1¡¡¹¤×÷±íµÄ¡¡A1¡¢A2¡¢A3¡¡µ¥Ôª¸ñ·Ö±ðÁ´½Óµ½¡¡sheet2¡¢sheet3¡¢sheet4¡¡¡¡



½â´ð£º1¡¢¡¡¡¡¡¡=indirect£¨¡¨sheet¡¨&row£¨£©£«1&¡¨£¡a1¡¨£©¡¡¡¶³ÌÏãÖæµÄ½âÊÍ£ºindirect¡¡ÊÇ°ÑÎı¾±äΪµ¥¡¡

Ôª¸ñÒýÓõĺ¯Êý¡¡row£¨£©ÊÇÈ¡µ±Ç°Ðкš£ÀýÈçÔÚ¡¡a1¡¡ÊäÈë¸Ã¹«Ê½£¬Ôò¡¡row£¨£©=1£¬¹«Ê½ÀïµÄÖµ±äΪ¡¡

indirect£¨¡¨sheet2£¡a1¡¨£©£»¸ú£½sheet2£¡a1¡¡Í¬Ð§£¬ÔÚa2¡¡ÊäÈë¸Ã¹«Ê½£¬Ôò¡¡row£¨£©=2£¬¹«Ê½ÀïµÄÖµ±ä¡¡

Ϊ¡¡indirect£¨¡¨sheet3£¡a1¡¨£©¡·¡¡¡¡

2¡¢Ê¹ÓòåÈë¡­¡­¡­¡­³¬¼¶Á´½Ó¡­¡­¡­¡­ÊéÇ©¡­¡­¡­£¨Ñ¡Ôñ£©¡­¡­¡­¡­È·¶¨¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Óá¡SUMIF¡¡º¯Êý½øÐÐÌõ¼þÇóºÍ£¬²»ÏÞÓÚÒ»¸öÌõ¼þʱÈçºÎÉèÖòÎÊý¡¡¡¡



ÀýÈ磺ÓÐÒ»¸ö±í¸ñµÇ¼ÇÃæ·Û¡¢Ã×·Û¡¢Å´Ãס¢¹£Ãס¢Â̶¹¡¢ÔçÃס¨¡¨µÈµÈµÄ½ø³öÁ÷Ë®ÕÊ£¬Èç¹û¶Ô¡¡

Âú×ãµ¥Ò»Ìõ¼þµÄÈçÃæ·Û¡¢Å´Ãס¢Â̶¹µÈ·Ö±ðÇóºÍÊÇûÓÐÎÊÌâµÄ£¬µ«Èç¹ûÒª½«Í¬Ò»ÀàµÄÇóºÍ£¬Àý¡¡

È罫ŴÃס¢¹£Ãס¢ÔçÃ×µÄÊýÖµ¼ÓÔÚÒ»Æð£¬Ó¦¸ÃÔõô°ì£¿¡¡¡¡¡¡

½â´ð£ºÌṩÒÔϹ«Ê½¹©²Î¿¼£¬Éè¡¡A¡¡ÁÐΪÃû³Æ¡¢B¡¡ÁÐΪÊýÁ¿£º¡¡¡¡

=SUMIF£¨A£ºA£»¡¨Å´Ãס¨£»B£ºB£©£«SUMIF£¨A£ºA£»¡¨¹£Ãס¨£»B£ºB£©£«SUMIF£¨A£ºA£»¡¨ÔçÃס¨£»B£ºB£©¡¡¡¡

Èç¡¡B1£ºD1¡¡ÎªÇóºÍÌõ¼þÏ¼´¡¡B1=¡¨Å´Ãס¨£»C1=¡¨¹£Ãס¨£»D1=¡¨ÔçÃס¨£»¡¡¡¡

ÉÏÊö¹«Ê½»¹¿É¸ÄΪ£º¡¡¡¡

=SUMIF£¨A£ºA£»B1£»B£ºB£©£«SUMIF£¨A£ºA£»C1£»B£ºB£©£«SUMIF£¨A£ºA£»D1£»B£ºB£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÈçºÎÔÚ¡¡excel¡¡ÖÐÒÑÓеÄÊýֵǰ¼ÓÁã±ä³ÉÁùλ¡¡¡¡



±ÈÈç˵¡¡25¡¢369¡¢1569¡¡µÈ£¬²Ù×÷ºó±ä³É¡¡000025¡¢000369¡¢00156¡¡¡¡

½â´ð£ºÈç¹ûÖ±½ÓÊäÈëµÄ»°£¬¿ÉÒÔÔÚÊýֵǰÃæ¼Ó¡°'¡±£¬Èç¡°'002020¡±£»¡¡¡¡¡¡

Èç¹û´¦ÀíÏֳɵÄÊý¾Ý£¬»òÕߴӱ𴦣¨±ÈÈç´Ó¡¡A1¡¡µ¥Ôª¸ñ£©Á´½ÓÀ´µÄÊý¾Ý£¬¿ÉÒÔÓù«Ê½£º¡¡¡¡

£½RIGHT£¨¡¨00000¡¨&A1£»6£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÈçºÎÌáÈ¡¹¤×÷±íÖеı³¾°Í¼Æ¬¡¡¡¡



½â´ð£ºÕÒ¸ö¸É¾»µÄµØ·½£»¡¡È¥µôÍøÎƵȲ»ÐèÒªµÄ¶«Î÷£»¡¡PrintScreen¡¡Ôٱ༭¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡»æÖÆÓÐÈýÌõбÏߵıíÍ·¡¡¡¡



½â´ð£º1¡¢Óûæͼ¹¤¾ß»­³öбÏß¡·¡·»­·½¿ò¡·¡·ÄÚÌí¼ÓÎÄ×Ö¡·¡·È¥±ß¿ò¡¡¡¡

2¡¢ÒýÓÃWORD¡¡Öеģ¬È»ºóÔÙ¸´ÖƹýÀ´¾Í¿ÉÒÔ£¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡350¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡351¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÔÚ¡¡A¡¡ÁÐÓÐÒ»×éÊý¾Ý²»ÊÇ°´ÕÕ´óС˳ÐòÅÅÁÐÔÚ¡¡B¡¡ÁÐÖÐÅÅÃû¡¡¡¡



½â´ð£º·½·¨¡¡1¡¢½«A¡¡ÁС¡COPY¡¡µ½¡¡B¡¡ÁУ¬ÔÙÅÅÐò¡£¡¡¡¡

2¡¢rank¡¡º¯Êý£¨=RANK£¨A2£ºA11£»A2£ºA11£»0£©£¨¼ÙÉèÊý¾ÝÔÚ¡¡A2£ºA11¡¡µ¥Ôª¸ñ£¬ÏÂͬ£©¡¡¡¡

3¡¢Ê¹Ó