å¦ä¸å¾ï¼å°A1:C6çæ°æ®è½¬å为ä¸å
1. å¨E1è¾å ¥å ¬å¼=INDEX(A:C,INT(ROW(A3)/3),MOD(ROW(A1)-1,3)+1)&""ï¼å车ï¼ä¸æå ¬å¼
2. å ¬å¼æ ¸å¿ï¼æ¥çè¡æ°ä¸åæ°çååè§å¾ï¼å©ç¨rowå½æ°ä½åºæ¥ï¼è¿ä¸ªä¾åä¸ï¼è¡ååæ¯111222333â¦â¦åååæ¯123123123â¦â¦ï¼äºæ¯å°±æäºINT(ROW(A3)/3)ï¼è¿ä¸ªä¸æå¾å°çå°±æ¯è¡ååç111222333â¦â¦ï¼MOD(ROW(A1)-1,3)+1)å¾å°çå°±æ¯åååç123123123â¦â¦ï¼è³äºindexå½æ°çç¨æ³å¯ä»¥ç¾åº¦ï¼ä¹å¯ä»¥çexcelçå½æ°å¸®å©ï¼æ¯è¾ç®åï¼ä¸å¨è§£éï¼æåç&""ï¼ä½ç¨æ¯å»ææåç0å¼ï¼æ²¡ææ°æ®åï¼å°±ä¸æ¾ç¤ºå 容äºï¼å»æçè¯ï¼æåé£999å®äºä»¥åï¼ä¸è¾¹çé½æ¯0
3. å¦å¤ä½¿ç¨indirectå½æ°ä¹æ¯å¯ä»¥çï¼=INDIRECT("r"&INT(ROW(A3)/3)&"c"&MOD(ROW(A1)-1,3)+1,)
已经知道了 谢谢哈
真的太感谢了 对了!
本回答被提问者采纳