å¨Excelä¸é¤äºå¯ä»¥é对æ个æ é¢å段è¿è¡çéå¤ï¼è¿å¯ä»¥ä½¿ç¨âé«çº§âçéåè½æ¥æ¾ç¬¦åå¤ä¸ªæ¡ä»¶çæ°æ®è®°å½ã使ç¨âé«çº§âçéåè½ï¼å¯å¿«ééæ©åæ¶æ»¡è¶³å¤ä¸ªæ¡ä»¶æä»
满足å¤ä¸ªæ¡ä»¶ä¸çä¸ä¸ªæ¡ä»¶çæ°æ®ãå¦è¦æ¥çéå®é¨âåâå§åå·¥çæ¡£æ¡ä¿¡æ¯ï¼å°±éå¨çéæ¡ä»¶åºåä¸å°ä¸¤ä¸ªæ¡ä»¶å¼å¡«åå¨åä¸è¡ä¸ï¼å
·ä½æä½æ¥éª¤å¦ä¸ã
å¤å¶å·¥ä½è¡¨
å次å¤å¶â人äºä¿¡æ¯æ°æ®è¡¨âï¼å¹¶å°å¤å¶çå·¥ä½è¡¨éå½å为âé«çº§çéâã
建ç«çéæ¡ä»¶
å¨æ°æ®åºåçå³ä¾§å»ºç«çéæ¡ä»¶åºåï¼å¹¶å¨å
¶ä¸è¾å
¥çéæ¡ä»¶ã
åå»âé«çº§âæé®
éæ©æ°æ®åºåä¸çä»»æåå
æ ¼ï¼è¿ééæ©G2åå
æ ¼ï¼åæ¢è³âæ°æ®âé项å¡ï¼å¨âæåºåçéâç»ä¸åå»âé«çº§âæé®ã
设置é«çº§çéåæ°
å¼¹åºâé«çº§çéâ对è¯æ¡ï¼éæ©âå¨åæåºåæ¾ç¤ºçéç»æâåéæé®ï¼å°âå表åºåâ设置为$A$2:$I$21ï¼âæ¡ä»¶åºåâ设置为$K$2:$L$3ï¼åå»âç¡®å®âæé®ã
æ¾ç¤ºçéç»æ
æ¤æ¶ï¼å¨å·¥ä½è¡¨ä¸ä»
æ¾ç¤ºäºéå®é¨âåâå§åå·¥çä¿¡æ¯ã
温馨提示:答案为网友推荐,仅供参考