不固定姓名列 取不重複 (12726)

F2{=INDIRECT(TEXT(MIN(IF((COUNTIF(F$1:F1,A$2:D$11)=0)*(A$2:D$11<>"")*(A$2:D$11<>"姓名")*(MOD({1,2,3,4},4)<>3),ROW($2:$11)/1%+{1,2,3,4},9999)),"!R0C00"),)&""



留言