ããæ¯è¾ç®åçå
¬å¼ï¼
ãã=SUBSTITUTE(ADDRESS(1,COLUMN(),4),1,"")
ããè¿æ¯æ 论åªä¸ªåå
æ ¼é½æ第1è¡ç¨ADDRESSæ¥åå¾å°åï¼åæå°åä¸çæ°å1æ¿æ¢ä¸ºç©º
ããä¸é¢ç»åºç¨å¤æç¹çå
¬å¼ï¼å
ç¨ADDRESSæ¥åå¾å½ååå
æ ¼çå°åï¼ç¨MINåå¾å°åä¸æå
åºç°æ°åçä½ç½®ï¼æç¨LEFTæ¥åå¾æ°ååçåæ¯ï¼æå
åºç°æ°åçä½ç½®åå»1ï¼å°±æ¯å°åä¸åæ åæ¯ç个æ°ï¼
ãã=LEFT(ADDRESS(ROW(),COLUMN(),4),MIN(FIND(ROW($1:$10)-1,ADDRESS(ROW(),COLUMN(),4)&5^19))-1)
ããåæ¶æCtrl+Shift+Enterä¸é®è¾å
¥æ°ç»å
¬å¼
温馨提示:答案为网友推荐,仅供参考