=IF(ROW(A1)>MATCH(LARGE(IF(Sheet1!$A$1:$A$100-C1>=0,Sheet1!A$1:A$100),COUNTIF(Sheet1!A:A,">"&$C$1)),Sheet1!A:A,)-MATCH($C$1,Sheet1!A:A,),"",OFFSET(Sheet1!$B$1,MATCH($C$1,Sheet1!A:A,)-2+ROW(C1),))
同时按CTRL SHIFT 回车键，再下拉，
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024