每區間最大 依指定行數 (13505)

F2=IF(ROW(A1)>ROUND(COUNT(B:B)/D$2,),"",MAX(OFFSET(B$2,(ROW(A1)-1)*D$2,,D$2)))

格式化 B2:B21=MOD(INT((ROW(A1)-1)/D$2),2)