如题所述
å©ç¨âéæ©æ§ç²è´´âåè½æ¥å®ç°è¡¨æ ¼è¡å转æ¢ãå
·ä½æä½æ¹æ³ï¼éä¸è¦è¿è¡è½¬æ¢çè¡¨æ ¼æ°æ®ï¼ç¹å»âå¼å§âåè½åºä¸çâå¤å¶âæé®ã
ç¹å»è¦æ¾ç½®æ°æ®çåå æ ¼ä½ç½®ï¼æ¥çç¹å»âç²è´´â->âéæ©æ§ç²è´´â项ã
å¨å¼¹åºçâéæ©æ§ç²è´´âçªå£ä¸ï¼å¾éâ转置â项ï¼å¹¶ç¹å»âç¡®å®âæé®ã
ç¶åå°±å¯ä»¥çå°è¡¨æ ¼è¡å转æ¢æåã
5
å¦å¤ï¼æ们è¿å¯ä»¥éè¿å ¬å¼æ¥å®ç°è¡¨æ ¼è¡åäºæ¢æä½ã以B2åå æ ¼ä½ä¸ºåèï¼è¾å ¥å ¬å¼â=INDIRECT((ADDRESS(COLUMN(B2),ROW((B2)))))â并å¤å¶å°å ¶å®åå æ ¼å³å¯å®ç°è¡åäºæ¢æä½ã
ç¹å»è¦æ¾ç½®æ°æ®çåå æ ¼ä½ç½®ï¼æ¥çç¹å»âç²è´´â->âéæ©æ§ç²è´´â项ã
å¨å¼¹åºçâéæ©æ§ç²è´´âçªå£ä¸ï¼å¾éâ转置â项ï¼å¹¶ç¹å»âç¡®å®âæé®ã
ç¶åå°±å¯ä»¥çå°è¡¨æ ¼è¡å转æ¢æåã
5
å¦å¤ï¼æ们è¿å¯ä»¥éè¿å ¬å¼æ¥å®ç°è¡¨æ ¼è¡åäºæ¢æä½ã以B2åå æ ¼ä½ä¸ºåèï¼è¾å ¥å ¬å¼â=INDIRECT((ADDRESS(COLUMN(B2),ROW((B2)))))â并å¤å¶å°å ¶å®åå æ ¼å³å¯å®ç°è¡åäºæ¢æä½ã
温馨提示:答案为网友推荐,仅供参考