·¢²¼Ê±¼ä : ÐÇÆÚÎå ÎÄÕÂexcel¹¤×÷±íÖÆ×÷ʵÀý¡¶½ÌѧÒÇÆ÷Á÷Ë®ÕÊ¡· ·ÖÏíµç×Ó±í¸ñ¾Ñé¼¼ÇÉ£¨ÓÐͼÓÐÕæÏñ£©¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ9ff3ad5ed15abe23482f4dfc
Æä´Î½¨Á¢¡°·ÖÊýÌõ±í¡±¼´Sheet2£¬ÓÃÓÚÒýÓóɼ¨ÐÅÏ¢£¬Í¬Ê±²úÉú³É¼¨±íÐÎʽ֮·ÖÊýÌõ£¨ÏÂÃæµÄ²Ù×÷¾ùÔڴ˱í½øÐУ©¡£
3¡¢ÊäÈ빫ʽ
½«¹«Ê½=CHOOSE(MOD(ROW(),4)+1,\4+1,),\ÊäÈëµ½Sheet2ÖеÄA1ÖÁI40ÇøÓòµÄµ¥Ôª¸ñÖÐ,Ç°ÃæÓнéÉÜÌî³ä±úÍÏק·¨¿ìËÙ¸´Öƹ«Ê½£¬ÏÂÃæ¸ø´ó¼ÒÔÙ½éÉÜÁíÒ»ÖÖ¿ìËÙ¸´ÖƵ¥Ò»¹«Ê½µÄ·½·¨£¬²½ÖèÈçÏ£º
Ñ¡¶¨Ìî³äÇøÓò£º¿ÉÒÔÓÃÊó±êÑ¡È¡£¬ÔÚÕâÀïʹÓÃÈçÉÏͼ·½·¨£¬¿ÉÒÔ¿ìËÙÑ¡ÔñÏëÑ¡ÔñµÄÇøÓò£¨ÈçÉÏÍòÐУ©£¬Ê×ÏÈÔÚÃû³Æ¿òÊäÈëÌî³äÇøÓò×óÉ϶˼°ÓÒ϶˵ĵ¥Ôª¸ñ£¨±¾ÀýÊäÈëA1:I40£©ºó°´»Ø³µ¼ü¡£
25
ÊäÈ빫ʽ£ºÔÚ±à¼À¸ÊäÈ빫ʽ
=CHOOSE(MOD(ROW(),4)+1,\4+1,),\ºó£¬Í¬Ê±°´Ctrl+»Ø³µ¼ü¡£ 4¡¢ÉèÖñ߿ò
Ñ¡ÔñA1:I4µ¥Ôª¸ñ£¬°´ÉÏͼÉèÖúñ߿ò¡ª¡ª¸´ÖÆ¡ª¡ªÑ¡ÔñA5:I40µ¥Ôª¸ñ¡ª¡ªÕ³Ìù¡ª¡ªÑ¡ÔñÐÔÕ³Ìù£¨¸ñʽ£©
5¡¢¶àÐбíÍ·£ºÈç2ÐбíÍ·µÄ¹«Ê½£º=CHOOSE(MOD(ROW(),5)+1,\Sheet1!A$2,OFFSET(Sheet1!A$1,ROW()/5+2,),\
26
Ê®¡¢ÉèÖÃÒ³Âë
С¼¼ÇÉ·ÖÏí£ºexcelÈçºÎʵÏÖÔÚ±íÍ·ÈÎһλÖÃÉèÖÃÒ³Â룿
½¨ÒéʹÓÃҳü/Ò³½ÅµÄ·½Ê½À´ÔÚ´òÓ¡³öµÄÿһҳµÄ±íÍ·ÖÐÕýÈ·ÏÔʾҳÂ루Ч¹ûͼÈçÉÏ£©¡£ÒÔÏÂÊǾßÌå²½Öè¡£
27
Ò³Ãæ²¼¾Ö¡ª¡ª´ò¿ª¡°Ò³ÃæÉèÖá±´°¿Ú¡ª¡ªµã¡°Ò³Ã¼/Ò³½Å¡±Ñ¡Ï¡ª¡ªµã»÷¡°×Ô¶¨ÒåÒ³
28