最高 低 提取 (11772)

F2=IF(ROW(A1)>D$2*2,"",LARGE(B:B,ABS(COUNT(B:B)*(ROW(A1)>D$2)-MOD(ROW(A1)-1,D$2)-(ROW(A1)<=D$2))))

格式化 B2:B17=RANK(B2,B:B,1)<=D$2

另解F2{=IF(ROW(A1)>D$2*2,"",ABS(LARGE(IF(B$2:B$99>0,-1^(ROW(A1)>D$2)*B$2:B$99),MOD(ROW(A1)-1,D$2)+1)))