ä¾ï¼æ±1è³10è¡ååæåä¸ä¸ªæ°åï¼å¦ä¸å¾ï¼
ä¸å¾A12å ¬å¼=MAX(IF(A2:A11,,A1:A10))ï¼æ³¨ææ±çæ¯A1ï¼A10ï¼ä½IFæ¡ä»¶åçæ¯A2ï¼A11ï¼æ¡ä»¶åºåä¸ç§»ä¸è¡ï¼å ¬å¼ä¸ºæ°ç»å ¬å¼ï¼ä¸é®ç»æï¼å ¬å¼ç¼ºç¹ï¼æåä¸ä¸ªæ°æ®åä¸è½æ0å¼æ空åå æ ¼ãå¦ææï¼ç¨ä¸è¾¹å ¬å¼
=INDEX(A1:A11,MAX((A1:A11>0)*ROW(1:11)))å ¬å¼ä¸ç11æ¹ä¸º10ä¹å¯ä»¥ï¼åæ ·æ¯æ°ç»å ¬å¼ï¼ä¸é®ç»æãCtrl+shift+enter