ããååºå¦ä¸ä¸ç§æ¹æ³ã1ã2è¾ä¸ºç´æ¥ï¼ä½ç解è¾é¾ã
ãã3æä½ç¨æ¾éº»ç¦ï¼ä½æ¯æäºç解ä¸å¯ä½å ¶å®ç¸å ³è¾åºã
ãã1ã=MAX((MID(A1,ROW($A:$A),1)="A")*ROW($A:$A))
ããè¯¥å ¬å¼éè¦ä½¿ç¨æ°ç»ï¼Ctrl+shift+enter
ãã2ã=LOOKUP(1,0/(MID(A1,COLUMN(1:1),1)="A"),COLUMN(1:1))
ãã3ãVBAèªå®ä¹å½æ°
ããAlt+F11æå¼VBAè¿è¡æ¡
ããæå ¥æ¨¡å
ããå¤å¶å¦ä¸ä»£ç å°ä»£ç æ¡å
ããå¨è¯¥sheetå å³å¯ä½¿ç¨å½æ°lastCå½æ°ï¼å é¨å å«ä¸¤ä¸ªåæ°ï¼å符串åæ¥æ¾çå符ã
Function LastC(myRange As Range, myC As String)