Excel word ppt officeʹÓü¼ÇÉ´óÈ«(DOC¸ñʽ)-µÚ72²¿·Ö

¿ì½Ý²Ù×÷: °´¼üÅÌÉÏ·½Ïò¼ü ¡û »ò ¡ú ¿É¿ìËÙÉÏÏ·­Ò³ °´¼üÅÌÉ쵀 Enter ¼ü¿É»Øµ½±¾ÊéĿ¼ҳ °´¼üÅÌÉÏ·½Ïò¼ü ¡ü ¿É»Øµ½±¾Ò³¶¥²¿! Èç¹û±¾ÊéûÓÐÔĶÁÍ꣬ÏëÏ´μÌÐø½Ó×ÅÔĶÁ£¬¿ÉʹÓÃÉÏ·½ "Êղص½ÎÒµÄä¯ÀÀÆ÷" ¹¦ÄÜ ºÍ "¼ÓÈëÊéÇ©" ¹¦ÄÜ£¡


£º=xlPart£»¡¡SearchOrder£º=xlByRows£»¡¡SearchDirection£º=xlUp£»¡¡MatchCase£º=¡¡_¡¡¡¡¡¡¡¡

False£©¡£Activate¡¡'ÕÒ×îºóÒ»±Ê¡¡¡¡¡¡¡¡

If¡¡ActiveCell¡£Row¡¡¡·=¡¡3¡¡Then¡¡¡¡¡¡¡¡

B¡¡=¡¡ActiveCell¡¡¡¡¡¡¡¡

S1¡¡=¡¡UCase£¨ActiveCell¡£Offset£¨0£»¡¡3£©£©¡¡'×îºóµÚ¡¡1¡¡±ÊÀ´»õ½á¹û¡¡¡¡¡¡¡¡

S2¡¡=¡¡UCase£¨ActiveCell¡£Offset£¨¡­1£»¡¡3£©£©¡¡'×îºóµÚ¡¡2¡¡±ÊÀ´»õ½á¹û¡¡¡¡¡¡¡¡

S3¡¡=¡¡UCase£¨ActiveCell¡£Offset£¨¡­2£»¡¡3£©£©¡¡'×îºóµÚ¡¡3¡¡±ÊÀ´»õ½á¹û¡¡¡¡¡¡¡¡

N1¡¡=¡¡ActiveCell¡£Offset£¨0£»¡¡0£©¡¡'×îºóµÚ¡¡1¡¡±Ê²úÆ·±àºÅ¡¡¡¡¡¡¡¡

N2¡¡=¡¡ActiveCell¡£Offset£¨¡­1£»¡¡0£©¡¡¡¡¡¡¡¡

N3¡¡=¡¡ActiveCell¡£Offset£¨¡­2£»¡¡0£©¡¡¡¡¡¡¡¡

If¡¡S1¡¡=¡¡¡¨PASS¡¨¡¡And¡¡S2¡¡=¡¡¡¨PASS¡¨¡¡And¡¡S3¡¡=¡¡¡¨PASS¡¨¡¡And¡¡N1¡¡=¡¡N2¡¡And¡¡N1¡¡=¡¡N3¡¡Then¡¡'ÊÇ·ñΪÁ¬Ðø¡¡

3¡¡±Ê¡¡PASS¡¡¡¡¡¡¡¡

Range£¨¡¨H65535¡¨£©¡£End£¨xlUp£©¡£Offset£¨1£©¡£Select¡¡'ÕÒ×îºóÒ»±Ê¡¡¡¡¡¡¡¡

ActiveCell¡¡=¡¡B¡¡'Ãâ¼ì×ÊÁÏ·ÅÔÚ¡¡H¡¡À¸¡¡¡¡¡¡¡¡

End¡¡If¡¡¡¡¡¡¡¡

End¡¡If¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡422¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡423¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

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



Next¡¡I¡¡¡¡¡¡¡¡

999¡¡¡¡¡¡¡¡

Range£¨¡¨A1¡¨£©¡£Select¡¡¡¡¡¡¡¡

End¡¡Sub¡¡¡¡¡¡¡¡

·½·¨¡¡4¡¡£º¡¡¡¡

Sub¡¡checkparts£¨£©¡¡¡¡¡¡¡¡

'On¡¡Error¡¡Resume¡¡Next¡¡¡¡¡¡¡¡

Dim¡¡checksize¡¡As¡¡Integer¡¡¡¡¡¡¡¡

Dim¡¡samePN¡¡As¡¡Integer¡¡¡¡¡¡¡¡

Dim¡¡id¡¡As¡¡Integer¡¡¡¡¡¡¡¡

Dim¡¡acceptcount¡¡As¡¡Integer¡¡¡¡¡¡¡¡

Dim¡¡firstPN£»¡¡nextPN¡¡As¡¡String¡¡¡¡¡¡¡¡

Dim¡¡vendor¡¡As¡¡String¡¡¡¡¡¡¡¡

checksize¡¡=¡¡InputBox£¨¡¨Enter¡¡the¡¡number¡¡consecutive¡¡records¡¡to¡¡check¡¡for¡¡each¡¡PN¡¨£©¡¡¡¡¡¡¡¡

Columns£¨¡¨G£ºI¡¨£©¡£Select¡¡¡¡¡¡¡¡

Selection¡£ClearContents¡¡¡¡¡¡¡¡

Range£¨¡¨B1¡¨£©¡£Select¡¡¡¡¡¡¡¡

id¡¡=¡¡1¡¡¡¡¡¡¡¡

While¡¡ActiveCell¡£Value¡¡¡¡¡¨¡¨¡¡¡¡¡¡¡¡

firstPN¡¡=¡¡Trim£¨ActiveCell¡£Value£©¡¡¡¡¡¡¡¡

samePN¡¡=¡¡1¡¡¡¡¡¡¡¡

nextPN¡¡=¡¡Trim£¨ActiveCell¡£Offset£¨samePN£»¡¡0£©¡£Value£©¡¡¡¡¡¡¡¡

vendor¡¡=¡¡Trim£¨ActiveCell¡£Offset£¨0£»¡¡3£©¡£Value£©¡¡¡¡¡¡¡¡

Do¡¡While¡¡nextPN¡¡=¡¡firstPN¡¡¡¡¡¡¡¡

samePN¡¡=¡¡samePN¡¡£«¡¡1¡¡¡¡¡¡¡¡

nextPN¡¡=¡¡Trim£¨ActiveCell¡£Offset£¨samePN£»¡¡0£©¡£Value£©¡¡¡¡¡¡¡¡

Loop¡¡¡¡¡¡¡¡

If¡¡samePN¡¡¡·=¡¡checksize¡¡Then¡¡¡¡¡¡¡¡

For¡¡acceptcount¡¡=¡¡0¡¡To¡¡checksize¡¡¡¡1¡¡¡¡¡¡¡¡

If¡¡UCase£¨Trim£¨ActiveCell¡£Offset£¨acceptcount£»¡¡2£©¡£Value£©£©¡¡¡¡¡¨ACCEPTED¡¨¡¡Then¡¡Exit¡¡For¡¡¡¡¡¡¡¡

Next¡¡acceptcount¡¡¡¡¡¡¡¡

If¡¡acceptcount¡¡=¡¡checksize¡¡Then¡¡¡¡¡¡¡¡

Cells£¨id£»¡¡7£©¡¡=¡¡id¡¡¡¡¡¡¡¡

Cells£¨id£»¡¡8£©¡¡=¡¡firstPN¡¡¡¡¡¡¡¡

Cells£¨id£»¡¡9£©¡¡=¡¡vendor¡¡¡¡¡¡¡¡

id¡¡=¡¡id¡¡£«¡¡1¡¡¡¡¡¡¡¡

End¡¡If¡¡¡¡¡¡¡¡

End¡¡If¡¡¡¡¡¡¡¡

ActiveCell¡£Offset£¨samePN£©¡£Select¡¡¡¡¡¡¡¡

Wend¡¡¡¡¡¡¡¡

Columns£¨¡¨G£ºI¡¨£©¡£Select¡¡¡¡¡¡¡¡

With¡¡Selection¡£Font¡¡¡¡¡¡¡¡

¡£Name¡¡=¡¡¡¨Arial¡¨¡¡¡¡¡¡¡¡

¡£Size¡¡=¡¡9¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡423¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡424¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

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



¡£Strikethrough¡¡=¡¡False¡¡¡¡¡¡¡¡

¡£Supers¡¡cript¡¡=¡¡False¡¡¡¡¡¡¡¡

¡£Subs¡¡cript¡¡=¡¡False¡¡¡¡¡¡¡¡

¡£OutlineFont¡¡=¡¡False¡¡¡¡¡¡¡¡

¡£Shadow¡¡=¡¡False¡¡¡¡¡¡¡¡

¡£Underline¡¡=¡¡xlUnderlineStyleNone¡¡¡¡¡¡¡¡

¡£ColorIndex¡¡=¡¡xlAutomatic¡¡¡¡¡¡¡¡

End¡¡With¡¡¡¡¡¡¡¡

With¡¡Selection¡¡¡¡¡¡¡¡

¡£HorizontalAlignment¡¡=¡¡xlLeft¡¡¡¡¡¡¡¡

¡£VerticalAlignment¡¡=¡¡xlBottom¡¡¡¡¡¡¡¡

¡£WrapText¡¡=¡¡False¡¡¡¡¡¡¡¡

¡£Orientation¡¡=¡¡0¡¡¡¡¡¡¡¡

¡£AddIndent¡¡=¡¡False¡¡¡¡¡¡¡¡

¡£ShrinkToFit¡¡=¡¡False¡¡¡¡¡¡¡¡

¡£MergeCells¡¡=¡¡False¡¡¡¡¡¡¡¡

End¡¡With¡¡¡¡¡¡¡¡

Selection¡£Columns¡£AutoFit¡¡¡¡¡¡¡¡

Range£¨¡¨G1¡¨£©¡£Select¡¡¡¡¡¡¡¡

ActiveWindow¡£SmallScroll¡¡ToRight£º=2¡¡¡¡¡¡¡¡

End¡¡Sub¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÈçºÎÓò»Í¬ÑÕÉ«µÄ×ÖÌ壬½«ÊÖʽÊäÈëÓ빫ʽ¼ÆËã½á¹ûÇø·Ö¿ªÀ´¡¡¡¡



½â´ð¡¡1£º¿ÉÒÔÓÃÌõ¼þ¸ñʽ£¬Èç¡¡A1¡¡¸ñ£¬ÔòÌõ¼þ¸ñʽ¹«Ê½ÈçÏ£º¡¡¡¡=CELL£¨¡¨contents¡¨£»A1£©¡¡¡¡

½â´ð¡¡2¡¡£ºÓÃ×Ô¶¨Ò庯ÊýÁË£º¡¡¡¡

¡¡Function¡¡IsFormula£¨cl£©¡¡¡¡

adrs¡¡=¡¡cl¡£Address¡¡¡¡

If¡¡Left£¨Range£¨adrs£©¡£Formula£»¡¡1£©¡¡=¡¡¡¨=¡¨¡¡Then¡¡¡¡

IsFormula¡¡=¡¡True¡¡¡¡

Else¡¡¡¡

IsFormula¡¡=¡¡False¡¡¡¡

End¡¡If¡¡¡¡

End¡¡Function¡¡¡¡¡¡

Ìõ¼þ¸ñʽ¹«Ê½Îª£º¡¡¡¡

=IsFormula£¨A1£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÔõÑùÔڵ绰ºÅÂëÊéÖÐÌáÈ¡ÊÖ»úºÅÂë¡¡¡¡



½â´ð£º¼ÙÉè¡¡a1=3322211£»a2=13322121122£»a3=2503225¡¡¡¡

a4=£û=sum£¨£¨len£¨a1£ºa3£©=11£©*£¨a1£ºa3£©£©£ý¡¡¡¡

ÍêÉÆ£º½¨ÒéÔÙ¼ÓÒ»¸öµÚһλÊÇ¡¨1¡¨µÄÅжÏÌõ¼þ£»¡¡ÒÔÃⳤ;³¬¹ý¡¡11¡¡Î»µÄÇé¿ö¡¡¡¡

£û=SUM£¨£¨LEN£¨A1£ºA3£©=11£©*£¨A1£ºA3£©*£¨LEFT£¨A1£ºA3£»1£©=¡¨1¡¨£©£©£ý¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡424¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡425¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

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



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÊDz»ÊÇÓÃÊý×麯Êý½â¾ö£¿Çë½Ì¸÷λ¡¡¡¡



a1=aa£»¡¡b1=apple¡¡¡¡

a2=bb£»b2=orange¡¡¡¡

¡£¡£¡£¡£¡£¡¡¡¡

if£¨a11=aa£»¡¡Ôò¡¡b11=apple¡¡¡¡

if£¨a11=bb£»¡¡Ôò¡¡b11=orange¡¡¡¡

¡£¡£¡£¡£¡£¡£¡¡¡¡

ÊDz»ÊÇÓÃÊý×麯Êý½â¾ö£¿Çë½Ì¸÷λ¡£¡¡¡¡

½â´ð£º¡¡¡¡¡¡

Èç¹û¶ÔÓ¦¹Øϵ±È½Ï¶à£¬ÏÈÔÚÒ»¸ö¹¤×÷±íÖзÖÁ½ÁÐÊäÈë²éÕÒÖµ¼°²éÕÒ½á¹û£¬ÈçÔÚ¹¤×÷±í¡¡SHEET2¡¡

ÖеÄA¡¡ÁÐÊäÈë²éÕÒÖµ£¬B¡¡ÁÐÊäÈë¶ÔÓ¦µÄ½á¹û£¬ÔÚÁíÒ»¸ö¹¤×÷±íµÄ¡¡B1¡¡¸ñÖÐÓù«Ê½¡¡¡¡

=VLOOKUP£¨A1£»SHEET2£¡A£ºB£»2£»0£©¡¡¡¡

¼´¿É°´¸Ã±íµÄA1¡¡¸ñÖеÄÖµ£¬ÔÚ¡¡sheet2¡¡±íµÄ¡¡A¡¡ÁÐÖвéÕÒ²¢·µ»Ø¶ÔÓ¦¡¡B¡¡ÁеÄÖµ¡£¡¡¡¡

Èç¹û¶ÔÓ¦¹Øϵ²»¶à£¬¿ÉÓù«Ê½¡¡¡¡

=VLOOKUP£¨A1£»£û¡¨aa¡¨£»¡¨apple¡¨£»¡¨bb¡¨£»¡¨orange¡¨£»¡£¡£¡£¡£¡£¡££ý£»2£»0£©¡¡¡¡

×¢ÒâÆäÖеģ»ºÅ¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡ÓÖÎÊ£ºÔÚ¡¡SHEET1¡¡£¡B2¡¡ÊäÈë¡¡¡¡

¡¡¡¡¡¡¡¡=IF£¨A1=¡¨¡¨£»¡¨¡¨£»if£¨Ã»ÓÐÆ¥Å䣻¡¨ÕâÊÇлõºÅ¡¨£»vlookup£¨a1£»sheet2£¡a£ºb£»2£»0£©£©£©¡¡¡¡

¡¡¡¡¡¡¡¡ÈçºÎʵÏÖÉÏÃæÒªÇó¡££¨Ã»ÓÐÆ¥Å䣻¡¨ÕâÊÇлõºÅ¡¨£»£©¡¡¡¡

½â´ð£ºISNA£¨VLOOKUP£¨¡£¡£¡£¡££©£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¹ØÓÚÈÕÆڵĸñʽ»¯ÎÊÌâ¡¡¡¡



ÎÒÒª½ÓÊÕ»ã×ÜÊý¾Ý£»³öÉúÄêÔÂÓеÄд³É¡°58¡£5¡¡¡¡¡±ÓеÄд³É¡¨58¡£05¡¨¡¡¡¡ÎÒÏÖÔÚÐèҪͳһΪ¡¡1958¡£05£¨³£¡¡

¹æÐÍ£©ÔõÑùʵÏÖ¡£¡¡¡¡

½â´ð£º¡¡

=value£¨IF£¨LEN£¨A1£©¡·5£»LEFT£¨A1£»4£©&¡¨¡£¡¨&TEXT£¨RIGHT£¨A1£»LEN£¨A1£©¡­5£©£»¡¨00¡¨£©£»¡¨19¡¨&LEFT£¨A1£»2£©¡¡

&¡¨¡£¡¨&TEXT£¨RIGHT£¨A1£»LEN£¨A1£©¡­3£©£»¡¨00¡¨£©£©£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÁеÄÌøÔ¾ÇóºÍ¡¡¡¡



ÈôÓС¡20¡¡ÁУ¨Ö»ÓÐÒ»ÐУ©£¬Ðèû¼ä¸ô¡¡3¡¡ÁÐÇóºÍ£¬¸Ã¹«Ê½ÈçºÎ×ö£¿¡¡¡¡¡¡

Ç°ÃæÐÐÌøÔ¾ÇóºÍµÄ¹«Ê½²»¹ÜÓᣡ¡¡¡¡¡

½â´ð£º¼ÙÉè¡¡a1¡¡ÖÁ¡¡t1¡¡ÎªÊý¾Ý£¨¹²ÓС¡20¡¡ÁУ©£¬ÔÚÈÎÒâµ¥Ôª¸ñÖÐÊäÈ빫ʽ£º¡¡

=SUM£¨IF£¨MOD£¨TRANSPOSE£¨ROW£¨1£º20£©£©£»3£©=0£»£¨a1£ºt1£©£©¡¡¡¡¡£°´¡¡ctrl£«shift£«enter¡¡½áÊø¼´¿ÉÇó³ö¡¡

ÿ¸ôÈýÐÐÖ®ºÍ¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡EXECL¡¡Ä¬ÈÏÆðʼ¹¤×÷±íµÄº¯Êý¡¡¡¡



ÎÒ±àÖƵġ¡Exexl¡¡¹¤×÷±¡ÖÐÓÐÈô¸É¸ö¹¤×÷±í£»Ãû³Æ·Ö±ðΪ¡¨²ÎÊýÉèÖᨡ¢¡°Æ¾Ö¤»ã×Ü¡±¡¢¡°±¨±í¡±µÈµÈ¡£¡¡

ÎÒµÄÎÊÌâÊÇ£¬ÔÚÈÎÒâÒ»¸ö¹¤×÷±íÃûϱ£´æ¹¤×÷±¡ºó£¬Ï´ÎÖØдò¿ªÊ±£¬Ê×ҳĬÈÏÊÇ¡°²ÎÊýÉèÖᱡ£¡¡

ÇëÎÊÔõôÑùÉèÖᣡ¡¡¡

½â´ð£ºPrivate¡¡Sub¡¡Workbook_Open£¨£©¡¡¡¡

Sheets£¨¡¨²ÎÊýÉèÖᨣ©¡£Select¡¡¡¡

End¡¡Sub¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡425¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡426¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

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



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÔõÑùÒ»´ÎÐÔ°Ñ¿Æѧ¼ÇÊý¸Ä³ÉÎı¾£¿¡¡¡¡



½â´ð£ºb1=TEXT£¨A1£»¡¨#¡¨£©¡¡¡£ÏòÏÂÌî³ä£¨#ºÅ¸ñʽ·û£¬´ú±íÊý×Ö£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡excel¡¡µÄÁù´ó¡°Ìõ¼þ¡±¹¦ÄÜ¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡EXCEL97/2000£¬³ýÁ˾ßÓÐÇ¿´óµÄ±í¸ñ¹¦ÄÜÍ⣬¸ü¾ßÓÐÇ¿´óµÄÊý¾Ýͳ¼ÆÓë´¦Àí¹¦ÄÜ£¬ÓÈÆä¡¡



ÊÇʹÓÃÆä¡¡¡°Ìõ¼þ¡±¹¦ÄÜ£¬³£³£ÄÜÊÕµ½Ê°빦±¶µÄЧ¹û£¬Ôڴ˱ÊÕß¾Íͬ´ó¼Ò̸̸¡¡EXCEL¡¡µÄÌõ¼þ¡¡



¹¦ÄÜ£¨Îª·½±ãÆð¼û£¬±ÊÕßÔÚ´ËÒÔÈçͼ¡¡1¡¡°üº¬¹¤³Ì»ù±¾Çé¿öµÄ¶þά±í¸ñΪÀý£©¡£¡¡¡¡



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

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Ò»¡¢Ìõ¼þÇóºÍ¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡1¡¢µ¥Ìõ¼þÇóºÍ£ºÍ³¼Æ¡¡c1¡¡¹«Ë¾Ê©¹¤µÄ¹¤³Ì×ܽ¨ÖþÃæ»ý£¬²¢½«½á¹û·ÅÔÚ¡¡e18¡¡µ¥Ôª¸ñÖУ¬ÎÒÃÇ¡¡

Ö»ÒªÔÚ¡¡e18¡¡µ¥Ôª¸ñÖÐÊäÈ빫ʽ¡°=sumif¡¡£¨d2£ºd17£»¡¨c1¡¡¹«Ë¾¡¨£»e2£ºe17£©¡±¼´Íê³ÉÕâһͳ¼Æ¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡ÓÑÇéÌáÐÑ£ºÈç¹û¶Ô¡¡excel¡¡µÄº¯Êý²»Ì«ÊìϤ£¬ÔÚµ¥Ôª¸ñÖÐÖ±½ÓÊäÈ빫ʽÓÐÀ§ÄÑ£¬ÎÒÃÇ¿ÉÒÔÓá¡

¡¡¡°²åÈ뺯Êý¡±ÃüÁ»òÖ±½Ó°´¹¤¾ßÀ¸Éϵġ°Õ³Ìùº¯Êý¡±ÃüÁî°´Å¥£©£¬Ñ¡ÖÐÄãÐèÒªµÄº¯Êýºó£¬°´¡¡

ÆäÌáʾ²Ù×÷¼´¿ÉÍê³É¹«Ê½µÄÊäÈë¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡2¡¢¶àÌõ¼þÇóºÍ£ºÍ³¼Æ¡¡c2¡¡¹«Ë¾Ê©¹¤µÄÖÊÁ¿µÈ¼¶Îª¡°ºÏ¸ñ¡±µÄ¹¤³Ì×ܽ¨ÖþÃæ»ý£¬²¢½«½á¹û·Å¡¡

ÔÚ¡¡e19¡¡µ¥Ôª¸ñÖУ¬ÎÒÃÇÓá°Ìõ¼þÇóºÍ¡±¹¦ÄÜÀ´ÊµÏÖ£º¡¡¡¡

¡¡¡¡¡¡¡¡¢ÙÑ¡¡°¹¤¾ß¡úÏòµ¼¡úÌõ¼þÇóºÍ¡±ÃüÁÈôûÓдËÃüÁîÑ¡Ï¿ÉÒÔÓá°¼ÓÔغꡱµÄ·½Ê½À´Ôö¡¡

¼ÓÕâÒ»ÃüÁîÑ¡Ï£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖУ¬°´ÓÒÏ´ø¡°¨D¡±ºÅµÄ°´Å¥£¨´Ëʱ¶Ô»°¿ò±ä³ÉÀàËƹ¤¾ß¡¡

ÌõµÄ´°¿ÚÐÎʽ¸¡ÓÚ×ÀÃæÉÏ£©£¬ÓÃÊó±êÑ¡¶¨¡¡d1£ºi17¡¡ÇøÓò£¬²¢°´´°¿ÚÓұߴøºìÉ«¼ýÍ·µÄ°´Å¥£¨»Ö¡¡

¸´¶Ô»°¿ò״̬£©¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡¢Ú°´¡°ÏÂÒ»²½¡±£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖУ¬°´¡°ÇóºÍÁС±ÓұߵÄÏÂÀ­°´Å¥Ñ¡ÖС°½¨ÖþÃæ»ý¡±Ï¡¡

Ôٷֱ𰴡°Ìõ¼þÁС¢ÔËËã·û¡¢±È½ÏÖµ¡±ÓұߵÄÏÂÀ­°´Å¥£¬ÒÀ´ÎÑ¡ÖС°Ê©¹¤µ¥Î»¡±¡¢¡°=¡±£¨Ä¬¡¡

ÈÏ£©¡¢¡°c2¡¡¹«Ë¾¡±Ñ¡Ï×îºó°´¡°Ìí¼ÓÌõ¼þ¡±°´Å¥¡£Öظ´Ç°Êö²Ù×÷£¬½«¡°Ìõ¼þÁС¢ÔËËã·û¡¢¡¡

±È½ÏÖµ¡±ÉèÖÃΪ¡°ÖÊÁ¿µÈ¼¶¡±¡¢¡°=¡±¡¢¡°ºÏ¸ñ¡±£¬²¢°´¡°Ìí¼ÓÌõ¼þ¡±°´Å¥¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡¢ÛÁ½´Îµã»÷¡°ÏÂÒ»²½¡±£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖУ¬°´ÓÒÏ´ø¡°¨D¡±ºÅµÄ°´Å¥£¬ÓÃÊó±êÑ¡¶¨¡¡e19¡¡

µ¥Ôª¸ñ£¬²¢°´´°¿ÚÓұߴøºìÉ«¼ýÍ·µÄ°´Å¥¡£¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡426¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡427¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

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



¡¡¡¡¡¡¡¡¢Ü°´¡°Íê³É¡±°´Å¥£¬´Ëʱ·ûºÏÌõ¼þµÄ»ã×ܽá¹û½«×Ô¶¯¡¢×¼È·µØÏÔʾÔÚ¡¡e19¡¡µ¥Ôª¸ñÖС£¡¡¡¡¡¡

¡¡¡¡¡¡ÓÑÇéÌáÐÑ£ºÉÏÊö²Ù×÷ʵ¼ÊÉÏÊÇÊäÈëÁËÒ»¸öÊý×鹫ʽ£¬ÎÒÃÇÒ²¿ÉÒÔÏÈÔÚ¡¡e19¡¡µ¥Ôª¸ñÖÐÖ±½ÓÊä¡¡

È빫ʽ£º=sum£¨if£¨d2£ºd17=¡¨c2¡¡¹«Ë¾¡¨£»if£¨i2£ºi17=¡¨ºÏ¸ñ¡¨£»e2£ºe17£©£©£©£¬È»ºóÔÚ°´×¡¡¡ctrl£«shift¡¡

¼ü£¨·Ç³£¹Ø¼ü£¡£¡£¡£©µÄͬʱ°´Ï¡¡enter¡¡¼ü£¬Ò²¿ÉÒÔ´ïµ½ÉÏÊö¶àÌõ¼þÇóºÍ֮ĿµÄ¡£¡¡¡¡¡¡

¡¡£¨¡°Ìõ¼þÇóºÍ¡±µÄÁíÒ»ÕС£¡£¡£¡¡=SUMPRODUCT£¨B9£ºC14£»MOD£¨B9£ºC14£«1£»2£©£©¡¡¡¡¡¡



Óá¡Sunif£¨£©¡¡ÉèÖÃÇóºÍÌõ¼þ±È½ÏÀ§ÄѵÄʱºò£¬¿ÉÒÔ¿¼ÂÇÉÏÃæµÄ¹«Ê½£º¶Ô¡¡B9£ºC14¡¡¡¡ÖеÄżÊý½øÐÐÇó¡¡

ºÍ¡£¡¡¡¡



À©Õ¹£º¿ÉÒÔ¿¼Âǽ«¡¡MOD£¨£©¡¡Ìæ»»³ÉÏàÓ¦µÄÌõ¼þ¡££©¡¡¡¡



¡¡¡¡¡¡¡¡¶þ¡¢Ìõ¼þ¼ÆÊý¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡Í³¼ÆÖÊÁ¿µÈ¼¶Îª¡°ºÏ¸ñ¡±¹¤³ÌµÄÊýÄ¿£¬²¢½«½á¹û´æ·ÅÔÚ¡¡i18¡¡µ¥Ôª¸ñÖУ¬ÔÚ¡¡i18¡¡µ¥Ôª¸ñÖÐÊä¡¡

È빫ʽ£º=countif£¨i2£ºi17£»¡¨ºÏ¸ñ¡¨£©£¬µ±°´ÏÂÈ·¶¨°´Å¥ºó£¬Í³¼Æ½á¹û¨D¨DÊý×Ö¡¡5¡¡¼´×Ô¶¯ÔÚ¡¡i18¡¡

µ¥Ôª¸ñÖÐÏÔʾ³öÀ´¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡Èý¡¢Ìõ¼þ¸ñʽ¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡½«¹¤³ÌÔì¼ÛÔÚ¡¡500¡¡ÍòÔª£¨º¬¡¡500¡¡ÍòÔª£©ÒÔÉϵŤ³ÌÔì¼ÛÊýÖµÒÔºìÑÕÉ«ÏÔʾ³öÀ´£º¡¡¡¡¡¡

¡¡¡¡¡¡¡¡¢ÙÑ¡ÖС¡f2¡¡ÖÁ¡¡f17¡¡µ¥Ôª¸ñ£»¡¡¡¡¡¡

¡¡¡¡¡¡¢ÚÓá°¸ñʽ¡úÌõ¼þ¸ñʽ¡±ÃüÁ´ò¿ª¡°Ìõ¼þ¸ñʽ¡±¶Ô»°¿ò£»¡¡¡¡¡¡

¡¡¡¡¡¡¡¡¢Û°´µÚ¶þ¸ö·½¿òÅÔµÄÏÂÀ­°´Å¥£¬Ñ¡ÖС°´óÓÚ»òµÈÓÚ¡±Ñ¡ÏÔÙÔÚºóÃæµÄ·½¿òÖÐÊäÈëÊý×Ö¡¡

500£»¡¡¡¡¡¡

¡¡¡¡¡¡¢Ü°´ÉÏÊö¶Ô»°¿òÖеġ°¸ñʽ¡±°´Å¥£¬´ò¿ª¡°µ¥Ôª¸ñ¸ñʽ¡±¶Ô»°¿ò£¬ÔÚ¡°ÎÄ×Ö¡±¿¨Æ¬Ï£¬°´¡¡

¡¡¡°ÑÕÉ«¡±ÅÔµÄÏÂÀ­°´Å¥£¬½«ÎÄ×ÖÑÕÉ«ÉèÖóɺìÉ«ºó£¬°´¡°È·¶¨¡±°´Å¥¹Ø±Õ¡°µ¥Ôª¸ñ¸ñʽ¡±¶Ô»°¡¡

¿ò£¬»Øµ½¡°Ìõ¼þ¸ñʽ¡±¶Ô»°¿òÖУ»¡¡¡¡¡¡



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

¡¡¡¡¡¡¡¡¢Ý°´¡°È·¶¨¡±°´Å¥¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡´ËʱÔì¼Û´óÓÚ¡¡500¡¡ÍòÔªµÄ¹¤³Ì£¬ÆäÔì¼ÛÊýÖµ½«ÒÔºìÉ«ÏÔʾÔÚµ¥Ôª¸ñÖС£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡ÓÑÇéÌáÐÑ£º¼ÌÐø°´ÉÏÊö¡°Ìõ¼þ¸ñʽ¡±¶Ô»°¿òÖеġ°Ìí¼Ó¡±°´Å¥£¬¿ÉÒÔÉèÖö༶¡°Ìõ¼þ¡±£¬¡¡

Èç¡°¹¤³ÌÔì¼Û´óÓÚ¡¡500¡¡ÍòÔªÒÔºìÉ«ÏÔʾ£¬´óÓÚ¡¡1000¡¡ÍòÔªÒÔÀ¶É«ÏÔʾ¡±µÈ£¨¿ÉÒÔ¶ÔÒ»¸öµ¥Ôª¸ñ¡¡

ÉèÖÃÈý¸öÌõ¼þ£©¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡ËÄ¡¢Ìõ¼þº¯Êý¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡ÎÒÃÇÔÚ¶Ô¿¢¹¤¹¤³Ì¹Û¸ÐÖÊÁ¿½øÐÐÆÀ¶¨ºó£¬µ±¹Û¸ÐµÃ·ÖÂʳ¬¹ý¡¡85£¥£¬¸Ã¹¤³ÌÖÊÁ¿µÈ¼¶¿ÉÒÔÆÀ¡¡

¶¨Îª¡°ÓÅÁ¼¡±¡£¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡427¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡428¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

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



¡¡¡¡¡¡¡¡¢ÙÔÚ¡¡i2¡¡µ¥Ôª¸ñÖÐÊäÈ빫ʽ£º=if£¨h2¡·=85£»¡¨ÓÅÁ¼¡¨£»if£¨h2¡·0£»¡¨ºÏ¸ñ¡¨£»¡¨Î´¿¢¹¤¡¨£©£©£»¡¡¡¡¡¡

¡¡¡¡¡¡¡¡¢ÚÑ¡ÖС¡i2¡¡µ¥Ôª¸ñ£¬½«Êó±êÒÆÖÁ¸Ãµ¥Ôª¸ñÓÒϽdzÉϸʮ×ÖÏßʱ£¨ÎÒÃdzÆ֮Ϊ¡°Ìî³ä±ú¡±£©£¬¡¡

°´×¡×ó¼üÏòÏÂÍÏÀ­£¬½«ÉϹ«Ê½¸´ÖƵ½¡¡i¡¡ÁÐÏÂÃæµÄµ¥Ôª¸ñÖУ»¡¡¡¡¡¡

¡¡¡¡¡¡¡¡¢ÛÒÔºóµ±¹¤³Ì¿¢¹¤ºó£¬ÎÒÃǽ«¸Ã¹¤³ÌµÄ¹Û¸ÐµÃ·ÖÂÊÌîÈë¡¡h¡¡ÁÐÄÚÏàÓ¦µÄµ¥Ôª¸ñÖУ¬ÔòÖÊÁ¿µÈ¡¡

¼¶×Ô¶¯ÏÔʾÔÚÏàÓ¦¹¤³ÌµÄ¡¡i¡¡Áе¥Ôª¸ñÖУ¨ÈôûÓÐÌî¹Û¸ÐµÃ·ÖÂÊ£¬Ôò¡¡i¡¡ÁÐÏàÓ¦µ¥Ôª¸ñÖÐÏÔʾ¡°Î´¡¡

¿¢¹¤¡±×ÖÑù£©¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡ÓÑÇéÌáÐÑ£ºÔÚµÚ¢Ù²½ÊäÈ빫ʽʱ£¬Ìõ¼þÅжÏÊý×Ö°´´Ó´óµ½Ð¡µÄ˳ÐòÅÅÁУ¬·ñÔò»á³ö´í¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡Îå¡¢Ìõ¼þ²éÕÒ¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡µ±¹¤³Ì»ù±¾Çé¿ö±íÖеǼǵŤ³Ì·Ç³£Ö®¶àʱ£¬Èç¹ûÎÒÃÇÓÃÆÕͨä¯ÀÀµÄ·½Ê½²éÕÒij¸ö¾ßÌåµÄ¡¡

¹¤³ÌÊǷdz£À§Äѵģ¬´ËʱÎÒÃÇ¿ÉÒÔÓá°²éÕÒ¡±¹¦ÄÜÀ´¿ìËÙ¶¨Î»£º¡¡¡¡¡¡

¡¡¡¡¡¡¡¡¢Ù¡¡Óᰱ༭²éÕÒ¡±ÃüÁ´ò¿ª¡°²éÕÒ¡±¶Ô»°¿ò£»¡¡¡¡¡¡



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

¡¡¡¡¡¡¡¡¢ÚÔÚ¡°²éÕÒÄÚÈÝ¡±ÏÂÃæµÄ·½¿òÖÐÊäÈë¸Ã¹¤³ÌµÄ¹Ø¼ü´Ê£»¡¡¡¡¡¡

¡¡¡¡¡¡¡¡¢Û¶Ô¡°ËÑË÷·½Ê½¡¢ËÑË÷·¶Î§¡±×÷Êʵ±ÉèÖúó£¬Á¬Ðø°´¡°²éÕÒÏÂÒ»¸ö¡±°´Å¥£¬·ûºÏÄ£ºýÌõ¼þ¡¡

µÄµ¥Ôª¸ñÒÀ´Î±»Ñ¡ÖУ¬¼´¿É¿ìËÙ²éÕÒµ½Ä³¸ö¾ßÌåµÄ¹¤³Ì¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡ÓÑÇéÌáÐÑ£ºÔÚ¡°²éÕÒÄÚÈÝ¡±ÏÂÃæµÄ·½¿òÖÐÊäÈëµÄÄÚÈݲ»Ò»¶¨·ÇµÃÓëijһµ¥Ôª¸ñÊýÖµÍê³ÉÏà¡¡

ͬµÄÎı¾£¬Èç²éÕÒ¡°c1¡¡¹«Ë¾¡±µÄij¸ö¹¤³Ì£¬Ö»ÒªÊäÈë¡°c1¡±¼´¿ÉÒÔ½øÐÐÄ£ºý²éÕÒÁË¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡Áù¡