=MAX(IF(C:C<>"",ROW(C:C),0))-LARGE(IF(C:C<>"",ROW(C:C),0),2)-1
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼
追é®é常æè°¢ï¼è¿æ个æ¡ä»¶å¿äºè¯´ï¼å°±æ¯è¦ä»ç¬¬äºä¸ªåå æ ¼C5æå¼å§ç®ï¼ä¹åé½æ¯æ é¢ä»¥åå并åå æ ¼ã
追çä¸è¡æ
åµä¸ï¼å³ä½¿ä»ç¬¬5个åå
æ ¼å¼å§ï¼ç»ä½ çå
¬å¼æ¯å¯è¡ãå½ç¶ä¹å¯ä»¥åªä»ç¬¬5个åå
æ ¼å¼å§è®¾ç½®å
¬å¼ï¼
=MAX(IF(C5:C65536"",ROW(5:65536),0))-LARGE(IF(C5:C65536"",ROW(5:65536),0),2)-1
åæ ·æ°ç»å
¬å¼ã