排序姓名 依日期 非空 (12061)

F2:F7 {=INDEX(A:A,RIGHT(SMALL(IF($B$2:$D$7=1,ROW($2:$7)+{2,3,4}/1%),ROW(A1)),2))

G2:G7 {=INDEX(A:A,RIGHT(LARGE(IF($B$2:$D$7<>"",ROW($2:$7)+{2,3,4}/1%+B$2:D$7/1%%),ROW(A1)),2))