å
¬å¼æ两å¤é误ï¼
1ã(ROW(),2)=0è¿æ¯ä»ä¹ææï¼ä¼°è®¡æ¯è¦éæ©å¶æ°è¡å§ï¼MOD(ROW(),2)=0
2ãVLOOKUP(ROW()-1,G3:I205,1,0)
å
¬å¼åå
æ ¼æå¨è¡å·å1ï¼æ¯å¦åå
æ ¼è¡å·ä¸º4ï¼åæ¥æ¾G3:I205ä¸çGåæ没æ3ï¼æ3è¿å3ï¼æ²¡3è¿åé误å¼ãé£ä¹IF((ROW(),2)=0,VLOOKUP(ROW()-1,G3:I205,1,0),"")è¿ä¸ªå
¬å¼çææ
å¦æä¸ç¬¦åæ¡ä»¶ï¼è¿ä¸ªæ¡ä»¶å¾
å®ï¼è¿å空å¼ï¼ç¬¦åæ¡ä»¶è¿åæå¨åå
æ ¼çä¸ä¸è¡è¡å·æ¯å¦ä¸é¢æ说ç3ï¼æè
é误ï¼G3ï¼G205没,3ï¼ã估计è¿æ ·çç»æä¹ä¸æ¯ä½ çç®çå§ï¼
温馨提示:答案为网友推荐,仅供参考