=IF(COUNTIF(A$1:A$10,A1)=1,A1,RANDBETWEEN(1,30))

我要回帖

 

随机推荐