如题所述
ããå¦æå为Cåï¼ä¸å¦¨è®¾ä¸ºC2:C100ï¼æ¬æ¥åºè¯¥æ¯æé®æä¾çãéæºæå10个ï¼è¥å¹²å
·ä½æ¯å¤å°ä¹åºè¯¥æé®æ¶æä¾çï¼æ°å°D2:D11ä¸ï¼æ¹æ³ï¼
ãã1. å å¨é项çå ¬å¼é项å¡ä¸å¾éâå¯ç¨è¿ä»£è®¡ç®âåç¡®å®
ãã2. å¨D2ä¸è¾å ¥å ¬å¼ï¼
ãã=IF(OR(COUNTIF(D$1:D2,D2)>1,D2=0),INDEX(C$2:C$100,RANDBETWEEN(1,99)),D2)
ããä¸æå°D11ï¼å³å¾å°ä»Cåéæºåå¾ç10个ä¸éå¤æ°ã
ããå¸æ追é®ä¸è¦è¶ åºæé®èå´ï¼æ ¹æ®ç»éªï¼è¿ç±»æ¨¡ç³æé®ï¼å¾å¾è¿½é®æ¶å°±æå¾å¤è¿½å æ¡ä»¶äºï¼èæé®æ¶å´æ¯é£ä¹æ墨å¦éã
ãã1. å å¨é项çå ¬å¼é项å¡ä¸å¾éâå¯ç¨è¿ä»£è®¡ç®âåç¡®å®
ãã2. å¨D2ä¸è¾å ¥å ¬å¼ï¼
ãã=IF(OR(COUNTIF(D$1:D2,D2)>1,D2=0),INDEX(C$2:C$100,RANDBETWEEN(1,99)),D2)
ããä¸æå°D11ï¼å³å¾å°ä»Cåéæºåå¾ç10个ä¸éå¤æ°ã
ããå¸æ追é®ä¸è¦è¶ åºæé®èå´ï¼æ ¹æ®ç»éªï¼è¿ç±»æ¨¡ç³æé®ï¼å¾å¾è¿½é®æ¶å°±æå¾å¤è¿½å æ¡ä»¶äºï¼èæé®æ¶å´æ¯é£ä¹æ墨å¦éã
温馨提示:答案为网友推荐,仅供参考