A3=INDEX(A:A,SMALL(IF(($J$2:$J$100<=2)*($K$2:$K$100>=3)*($K$2:$K$100<=10),ROW($A$2:$A$100),65536),ROW(A1)))&""同时按CTRL SHIFT 回车键,再右拉下拉