每二行取不重複 (12526)

F7:K11{=IF(MOD(ROW(A1),2),TEXT(MIN(IF(COUNTIF($E7:E7,$B6:$D7)=0,$B6:$D7)),"0;;"),"")

另解{=IF(MOD(ROW(A1),2),IFERROR(SMALL(IF(COUNTIF($E7:E7,$B6:$D7)=0,$B6:$D7),1),""),"")



留言