如何解决Excel从题库中随机抽取的题目不重复 Excel 题目随机抽取，怎么保证不重复
\u5982\u4f55\u89e3\u51b3Excel\u4ece\u9898\u5e93\u4e2d\u968f\u673a\u62bd\u53d6\u7684\u9898\u76ee\u4e0d\u91cd\u590d\u5462\uff1f1
\u5148\u5c06\u6240\u6709\u4e0d\u91cd\u590d\u7684\u9898\u76ee\u4f9d\u6b21\u7f16\u53f7
2
\u518d\u5c06\u6240\u6709\u7f16\u53f7\u653e\u5728a\u5217\u4f9d\u6b21\u6392\u5217
3
\u5c06\u4e0ea\u5217\u4e2d\u6709\u7f16\u53f7\u7684\u5355\u5143\u683c\u76f8\u90bb\u7684b\u5217\u5355\u5143\u683c\u90fd\u52a0\u4e0a\u968f\u673a\u51fd\u6570rand
4
\u70b9\u51fbb\u5217\u4e2d\u4efb\u610f\u4e00\u4e2a\u6709\u6570\u503c\u7684\u5355\u5143\u683c\uff0c\u518d\u70b9-\u6392\u5e8f
5
\u73b0\u5728\u53ea\u8981\u5728a\u5217\u4e2d\u9009\u62e9\u9700\u8981\u7684\u524dn\u4e2a\u9898\u76ee\u7f16\u53f7\u5373\u53ef
\u5047\u8bbeA\u5217\u662f\u9898\u76ee
\u5728B1 C1\u4e2d\u5206\u522b\u8f93\u5165\u6216\u590d\u5236\u7c98\u8d34\u4e0b\u5217\u516c\u5f0f
=RAND()
=RANK(B1,B:B)
\u9009\u62e9B1:C1\uff0c\u4e0b\u62c9\u586b\u5145
\u5728D\u5217\u8f93\u5165\u4e0d\u91cd\u590d\u7684\u6570\u503c
\u5728E1\u4e2d\u8f93\u5165\u6216\u590d\u5236\u7c98\u8d34\u4e0b\u5217\u516c\u5f0f
=INDEX(A:A,D1)
\u4e0b\u62c9\u586b\u5145
假设随机抽取50个题目；
对题库编号增加辅助列，辅助列取值=rand()；
以辅助列排序，取top50；
这样取出来的题就不重复了。
绛旓細鏂规硶1锛欼NDIRECT鍑芥暟+RANDBETWEEN鍑芥暟 鍦ㄥ崟鍏冩牸C1杈撳叆鍏紡:" =INDIRECT("a"&RANDBETWEEN(1,10)) "鐒跺悗鍥炶溅锛堝嵆鎸夆淓nter"閿級浣犱細鍙戠幇鍗曞厓鏍糃1涓洪殢鏈轰粠A1:A10鎻愬彇鐨勪竴涓暟銆傚皢榧犳爣鏀惧埌鍗曞厓鏍糃1鐨勫彸涓嬭锛岀瓑鍒伴紶鏍囨爣蹇楀彉涓哄皬鍗佸瓧锛屾寜涓嬮紶鏍囧乏閿劧鍚庡線涓嬫嫋锛屼綘浼氬彂鐜版嫋鍑虹殑鏁版嵁閮戒负闅忔満浠嶢1:A10鎻愬彇...
绛旓細1銆侀鍏堝湪Excel琛ㄦ牸涓緭鍏ラ渶瑕佸缓绔嬬殑鍔犲噺涔橀櫎鐨勯搴撴暟鎹紝骞朵笖鍦ㄩ搴鍙充晶鐨勭┖鐧藉崟鍏冩牸涓緭鍏闅忔満鍑芥暟鍏紡锛=rand()銆傘2銆佺偣鍑诲洖杞﹀苟涓嬫媺鍏紡鍗冲彲鐢熸垚涓缁勯殢鏈哄嚱鏁扮敓鎴愮殑鏁版嵁锛屾鏃堕渶瑕佸璁＄畻鐨勭粨鏋滆繘琛岀矘璐存暟鍊肩殑鎿嶄綔锛岄伩鍏嶉殢鏈哄嚱鏁板彂鐢熷彉鍖栥3銆侀変腑鎵鏈夊崟鍏冩牸骞剁偣鍑烩滃紑濮嬧濋夐」鍗′腑鐨勨滄帓搴忊濓紝鍙互杩涜...
绛旓細1銆佹墦寮銆岃〃鏍硷紙Excel锛夈嶆枃妗ｏ紱2銆侀夋嫨鎵闇绛涢夋暟鎹尯鍩燂紝鐐瑰嚮銆屾暟鎹-鑷姩绛涢夈嶏紱3銆佸睍寮绛涢夎缃脊绐锛屽嬀閫夈岄珮绾фā寮忋嶅嵆鍙紑鍚瓫閫夎鏁版ā寮忥紙鎻愮ず锛岃鍔熻兘闇寮閫歐PS浼氬憳浣跨敤锛夋洿澶氬姙鍏蒋浠堕棶棰橈紝鎺ㄨ崘鍘汇學PS瀛﹂櫌銆 瀵绘壘涓撲笟瑙嗛瑙ｈ锛堢櫨搴︽悳锛 WPS瀛﹂櫌 鍗冲彲锛塛PS瀛﹂櫌 锛 瀹樻柟鍑哄搧鐨勫厤璐筄ffice瑙嗛鎶宸...
绛旓細1銆鍒涘缓璇曞嵎鏃讹紝闇瑕佸厛璁剧疆濂借冭瘯鐨勫熀鏈俊鎭紙鑰冭瘯鍚嶇О銆佽冭瘯鍒嗙被銆佽冭瘯椤荤煡銆佽冪敓鍙傚姞鏂瑰紡銆佽冪敓闇瑕佸～鍐欑殑淇℃伅锛夛紝鐒跺悗灏卞彲浠ュ幓缁勫缓闅忔満璇曞嵎浜嗐2銆佸湪鍒涘缓闅忔満璇曞嵎鐨勬椂鍊欙紝鎴戜滑鍙互鑷畾涔夋坊鍔犲ぇ棰橈紝鐒跺悗閫夋嫨璇曢绫诲瀷銆佽瘯棰樺垎绫诲氨鍙互鐩存帴灏嗚瘯棰樺簱涓搴旂殑璇曢绛涢夎繘鏉ワ紝鍦ㄦ娊棰樻涓缃搴旂殑鎶介鏁伴噺鍗冲彲銆...
绛旓細1 鍏堝皢鎵鏈変笉閲嶅鐨勯鐩緷娆＄紪鍙 2 鍐嶅皢鎵鏈夌紪鍙锋斁鍦╝鍒椾緷娆℃帓鍒 3 灏嗕笌a鍒椾腑鏈夌紪鍙风殑鍗曞厓鏍肩浉閭荤殑b鍒楀崟鍏冩牸閮藉姞涓婇殢鏈哄嚱鏁皉and 4 鐐瑰嚮b鍒椾腑浠绘剰涓涓湁鏁板肩殑鍗曞厓鏍硷紝鍐嶇偣-鎺掑簭 5 鐜板湪鍙鍦╝鍒椾腑閫夋嫨闇瑕佺殑鍓峮涓鐩紪鍙峰嵆鍙
绛旓細涓嬪叕寮忓亣璁炬娊鍙100閬撻锛夛紝杈撳叆 =INDEX(B1:B100,MATCH(LARGE(A1:A100,ROW()),A1:A100,0))鎸塅2锛屾寜ctrl+shift+enter锛屼娇鍏舵垚涓烘暟缁勫叕寮 LARGE涔熷彲閫傜敤SMALL锛屽鏋滀笉鏄粠绗竴琛屽崟鍏冩牸閫夊彇锛屾敞鎰忎笉瑕佽ROW杩斿洖澶т簬100鐨勫硷紝搴旀妸ROW()鏀规垚ROW(A1:A100)鎸塅9鍗冲彲闅忔満鎺掑垪棰樺簱鐨勯『搴忋
绛旓細鍋囪闅忔満鎶藉彇50涓鐩紱瀵棰樺簱缂栧彿澧炲姞杈呭姪鍒楋紝杈呭姪鍒楀彇鍊=rand()锛涗互杈呭姪鍒楁帓搴忥紝鍙杢op50锛涜繖鏍峰彇鍑烘潵鐨勯灏变笉閲嶅浜嗐
绛旓細1銆鍦‥xcel涓娣诲姞宸ヤ綔琛ㄢ棰樺簱鈥濆綍鍏600閬撻搴撱2銆佸湪Excel涓坊鍔犲伐浣滆〃鈥滃崟浜洪夋嫨棰橀搴撯濄3銆佸湪Excel涓殑宸ヤ綔琛ㄢ滃崟浜洪夋嫨棰橀搴撯濇牴鎹闅忔満鎺掑簭鍚庣殑棰樺彿鎵惧埌閬撳搴旂殑棰樺共銆侀夋嫨棰樼瓟妗堛4銆佸湪Excel涓殑宸ヤ綔绨夸腑鏂板缓宸ヤ綔琛ㄢ滃嚭棰樹汉涓庢纭瓟妗堚濓紝鏍规嵁宸ヤ綔琛ㄢ滈殢鏈烘暟鈥濓紝杩愮敤vlookup鍑芥暟鎵惧埌姣忎竴濂...
绛旓細鍦sheet1閲岄潰鎶552閬撻鍏ㄩ儴褰曡繘鍘伙紝瑕佹眰搴忓彿銆侀銆佹爣鍑嗙瓟妗堜笁鑰呭繀椤诲湪鐙珛鍒椾腑锛屽湪sheet2涓敤randbetween鍑芥暟鐢熸垚1-552鐨闅忔満鏁存暟锛屼絾鏄仛鍒颁笉閲嶅杩橀渶瑕佽皟鏁翠竴涓嬶紝鐒跺悗鏍规嵁闅忔満鐢熸垚鐨勯鍙风敤鍑芥暟绛涢夊嚭棰橈紝鍐嶇敤IF鍑芥暟鏉ュ垽鏂瓟棰樿呯瓟妗堢殑瀵归敊
绛旓細鍙鏈棰樺簱婧愭暟鎹紝闅忔満閫夐寰堝鏄撶殑鍟娿傜敤闅忔満鍑芥暟鐢熸垚婧愰搴撴暟鎹殑琛屽彿锛岀劧鍚庣敤OFFSET銆両NDEX涔嬬被鐨勫嚱鏁板氨鍙互鐢熸垚闅忔満棰浜嗐
