随机 二列排一列 (10905)

E2:E17 区域数组{=IFERROR(RIGHT(LARGE(IF(B2:C9<>"",RANDBETWEEN((ROW(B2:B9)+{0,0})^0,999)/1%+B$2:C$9),ROW(1:16)),2)*1,"")

G2{=AND(COUNTIF(E:E,B2:C9)=COUNTIF(B:C,B2:C9))