不相鄰二數據排列 三條件次序 (13568)

K6{=IFERROR(INDIRECT(TEXT(RIGHT(MIN(IF(COUNTIF(K$5:K5,IF({1,0},C$6:C$10,G$6:G$10))=0,COUNTIF(C:G,IF({1,0},C$6:C$10,G$6:G$10))*10^8+ROW($6:$10)/1%+{3,7}*10001)),4),"!R0C00"),),"")

K6{=IFERROR(INDIRECT(TEXT(RIGHT(MIN(IF(COUNTIF(K$5:K5,IF({1,0},C$6:C$10,G$6:G$10))=0,COUNTIF(C:G,IF({1,0},C$6:C$10,G$6:G$10))*10^8+ROW($6:$10)/1%+{3,7}*10001)),4),"!R0C00"),),"")



留言