å¦æåå¾ä¸é£æ ·æè§å¾ï¼å¯ç¨ä»¥ä¸å ¬å¼
C2è¾å ¥
=MID(INDIRECT("A"&INT(ROW(A6)/3)),2*(MOD(ROW(A3),3)+1)-1,1)
å ¬å¼ä¸æ
追é®ä½ 好 ä¸å¥½ææ åé®ä¸ä¸ ææåºæ¥æä¹æ¯è¿æ ·ç
=MID(INDIRECT("A"&INT(ROW(A6)/3)),MOD(9*(ROW(A1)-1)+1,27),8)
ä¸æ