è§æ ·è¡¨æªå¾
æ¯å¦æAå满足大äº5çåå æ ¼æåå°Då
D1è¾å ¥
=INDEX(A:A,SMALL(IF($A$1:$A$10>5,ROW($1:$10),100),ROW(A1)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车
å ¬å¼ä¸æ
å¦æææ°æ®æåå°å¦ä¸è¡¨ï¼å
¬å¼æ¹ä¸º
=INDEX(sheet1!A:A,SMALL(IF(sheet1!$A$1:$A$10>5,ROW($1:$10),100),ROW(A1)))&""
å³å¯