每行5格非空 以主數字排序 (15017)

H2:L2 下拉{=IFERROR(INDEX(B:B,MOD(SMALL(IF(MMULT(N($B$2:$F$21<>""),{1;1;1;1;1})=5,$B$2:$B$21/1%%+ROW($2:$21)),ROW(A1)),100)),"")

格式化B2:F21=SUMPRODUCT(N($B2:$F2<>""))=5