以ä¸æ¯å·¥èµæ¡å¶ä½å
¬å¼ï¼
=IF(MOD(ROW(),3)=0,"",IF(MOD(ROW(),3)=1,å·¥èµè¡¨!A$1,INDEX(å·¥èµè¡¨!$A:$DC,INT((ROW()+4)/3),COLUMN())))
å
¬å¼ä¸ç âå·¥èµè¡¨â è¦å¯¹åºç¸åºçå·¥ä½è¡¨1.éæ©ç¬¬1è¡å第2è¡ï¼å¤å¶ï¼éæ©è¡¨æ ¼ä¸é¢ç©ºè¡ï¼ç²è´´
ï¼éæ©ç©ºè¡æ°ä¸ºäººæ°ç1åï¼ä½ æçï¼
2.éæ©ç¬¬2è¡ï¼å¤å¶ï¼éæ©è¡¨æ ¼ä¸é¢ç©ºè¡ï¼ç²è´´
3.å¨è¡¨æ ¼å³è¾¹ä¸åï¼æ¯å¦Såï¼å¨S3è¾å
¥1.2ï¼S4è¾å
¥2.2ï¼éæ©S3:S4ï¼å¡«å
å°äººæ°æåä¸è¡
4.å¨ä¸é¢ç²è´´çæ é¢è¡å¯¹åºçSåï¼æ¯å¦S50è¾å
¥1ï¼S51è¾å
¥2ï¼å¡«å
å°æ é¢æåä¸è¡
5.å¨ä¸é¢ç²è´´ç项ç®è¡å¯¹åºçSåï¼æ¯å¦S100è¾å
¥1.1ï¼S51è¾å
¥2.1ï¼å¡«å
å°é¡¹ç®æåä¸è¡
6.æåéæ©S1åå
æ ¼ï¼ç¹æåºï¼å°±åºæ¥å·¥èµæ¡äº
温馨提示:答案为网友推荐,仅供参考