如题所述
å·¥å ·ï¼excel 2007
åä¸ªæ ·è¡¨ï¼è¯¦è§æªå¾
åå§æ°æ®å¨ABCä¸åï¼
ç®æ ï¼ä¿ç第1,4,7.....è¡ï¼ä¹å°±æ¯æ¯é1è¡å é¤2è¡
æ¹æ³ï¼æ符åè¦æ±çæ´è¡æåå°DEFåï¼ç¶åç¨æ°3åå代æ§3åã
æ¥éª¤ï¼
å¨D1è¾å ¥ =IF(OFFSET($A$1,ROW(A1)*3-3,COLUMN(A1)-1)=0,"",OFFSET($A$1,ROW(A1)*3-3,COLUMN(A1)-1))
å ¬å¼å³æ2è¡åä¸æï¼ç´å°æ°æ®æ²¡æ为æ¢
å¤å¶DEF3å>å³é®>éæ©æ§ç²è´´>æ°å¼
å é¤ABCåã
ä¸å¾ä¸ºå é¤ååçææ