如题所述
è§æªå¾
æ¯å¦æåAå大äº10çæ°åå°Cå
C2è¾å ¥
=INDEX(A:A,SMALL(IF($A$2:$A$10>10,ROW($2:$10),100),ROW(A1)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车
å ¬å¼ä¸æ