è¯è¿äºï¼å¨A2åå æ ¼ä¸è¾å ¥ä½ ç»çå ¬å¼åæ¹æ³ï¼æctrl+shift+enterä¸é®ç»ååï¼ä»è½åºç°å 个ç¸åçéæºæ°åï¼è¯·å ·ä½è¯´æä¸ä¸å¦ä½ä¿®æ¹ï¼è°¢è°¢ã
追çå¦,ä¸å¥½ææå¿è®°æCæ¹ä¸ºAäº
A2ç²è´´å
¬å¼
=SMALL(IF(COUNTIF(A$1:A1,ROW($1:$100)),65536,ROW($1:$100)),ROUNDUP(RAND()*(101-ROW(A1)),))
æ¥éª¤ä¸æ ·