随机每人四个数据不重复 (11186)

B2:E6{=IF($A2="","",INDEX($G:$G,SMALL(IF(COUNTIF($A2:A2,$G$2:$G$10)=0,ROW($2:$10)),RANDBETWEEN(1,10-COLUMN(A1)))))