比我要A列随机在张明,李慧,王晓军,周娟,李梅,刘燕君,杨辉七名字抽取三个在B列用什么公式
=INDEX(A:A,C1)
=IF(ROW()=1,INT(RAND()*7+1),LARGE(IF(COUNTIF(INDIRECT("C1:C"&ROW()-1),ROW($1:$7)),,ROW($1:$7)),INT((8-ROW())*RAND()+1)))
下一篇:吴秀波一年能挣多少钱?
热门标签:
=INDEX(A:A,C1)
=IF(ROW()=1,INT(RAND()*7+1),LARGE(IF(COUNTIF(INDIRECT("C1:C"&ROW()-1),ROW($1:$7)),,ROW($1:$7)),INT((8-ROW())*RAND()+1)))
下一篇:吴秀波一年能挣多少钱?