Excel高效去重排序：3步搞定不重复数据整理
锛堟媿妗屽瓙锛夊悇浣嶆墦宸ヤ汉娉ㄦ剰浜嗭紒浠婂ぉ鍜变滑瑕佽亰鐨勮繖涓狤xcel鎶€鑳斤紝缁濆鑳借浣犲湪鍚屼簨闈㈠墠绉€涓€鎶婃搷浣滐紒鎯宠薄涓€涓嬶紝褰撲綘闈㈠鍑犵櫨琛岄噸澶嶆暟鎹劍澶寸儌棰濇椂锛岄殧澹佽€佺帇鍗村枬鐫€鍜栧暋涓変笅浜旈櫎浜屽氨鏁寸悊濂戒簡鈥斺€旇繖绉嶅満鏅槸涓嶆槸浼兼浘鐩歌瘑锛熷埆鎱岋紝鐪嬪畬杩欑瘒锛屼綘涔熻兘鎴愪负鍒汉鐪奸噷鐨?Excel澶х"锛?/p>
鈥?strong>鈥嬸煈?鐏甸瓊鎷烽棶锛氫负浠€涔堜綘鐨勬暟鎹€诲儚鎵撶粨鐨勬瘺绾垮洟锛熲€?/strong>鈥?br/> 浣犳槸涓嶆槸缁忓父閬囧埌杩欑鎯呭喌锛熼瀵肩敥杩囨潵涓€浠藉鎴峰悕鍗曪紝缁撴灉鍙戠幇鍚屼竴涓墜鏈哄彿鍑虹幇涓冨叓娆★紱鏈堝簳缁熻閿€鍞暟鎹紝浜у搧鍨嬪彿閲嶅寰椾翰濡堥兘涓嶈璇?..锛堟憡鎵嬶級杩欎簺閲嶅鏁版嵁灏卞儚楗噷鐨勬矙瀛愶紝纭屽緱浜洪毦鍙椼€備笉杩囧埆鎷呭績锛屼粖澶╄鏁欎綘鐨勮繖涓夋澘鏂э紝涓撴不鍚勭閲嶅涓嶆湇锛?/p>
绗竴姝ワ細鏁版嵁楂樹寒锛屾彧鍑洪噸澶嶉」锛?/h3>
锛堟暡榛戞澘锛夐噸鐐规潵浜嗭紒鍜变滑鍏堢粰閲嶅鏁版嵁"涓婂垜鍦?涔嬪墠锛屽緱鍏堟妸瀹冩彧鍑烘潵绀轰紬瀵逛笉瀵癸紵
鎵撳紑浣犵殑Excel琛ㄦ牸锛岄€変腑瑕佸鐞嗙殑鏁版嵁鍒楋紙姣斿A鍒楋級锛岀洿鎺ユ寜杩欎釜缁勫悎閿細
鈥?strong>鈥婥trl + Shift + L鈥?/strong>鈥?鈫?寮€鍚瓫閫夋ā寮?br/>
鐒跺悗鐐瑰嚮绛涢€夊皬涓夎锛岄€?鎸夐鑹茬瓫閫?鈫?鎸夊崟鍏冩牸棰滆壊绛涢€?
杩欐椂鍊欓噸澶嶆暟鎹氨鍍忓搴楅噷鐨勮崸鍏夋涓€鏍烽棯闂彂鍏夊暒锛?/p>
鈥?strong>鈥嬸煉?灏忕櫧鐨勫洶鎯戯細鈥?/strong>鈥?br/> "瑕佹槸涓嶅皬蹇冮€夐敊鍒楁€庝箞鍔烇紵"锛堟壎棰濓級鍒厡锛佽寰楀厛鎸夆€?strong>鈥婥trl+Z鈥?/strong>鈥嬫挙閿€鎿嶄綔锛屾垨鑰呯洿鎺ュ叧鎺夌瓫閫夐噸鏂伴€夈€侲xcel杩欑偣鐗瑰埆濂斤紝灏卞儚鎵撴父鎴忚兘瀛樻。閲嶆潵涓€鏍凤紒
绗簩姝ワ細鍒犻櫎閲嶅椤癸紝鎵嬭捣鍒€钀斤紒
锛堟悡鎵嬶級瑙佽瘉濂囪抗鐨勬椂鍒诲埌浜嗭紒閫変腑鏁村紶琛ㄦ牸锛屾壘鍒拌彍鍗曟爮鐨?鏁版嵁"閫夐」鍗★紝鐪嬪埌閭ｄ釜闂棯鍙戝厜鐨勨€?strong>鈥?鍒犻櫎閲嶅椤?鈥?/strong>鈥嬫寜閽病锛熷锛屽氨鏄畠锛?/p>
杩欓噷鏈変釜鈥?strong>鈥嬪繀鐪嬪姣旇〃鈥?/strong>鈥嬶細
| 鎿嶄綔鏂瑰紡 | 閫傚悎鍦烘櫙 | 椋庨櫓绛夌骇 |
|---|---|---|
| 鐩存帴鍒犻櫎 | 纭畾涓嶈浠讳綍閲嶅 | 猸愨瓙猸?/td> |
| 鏍囪棰滆壊 | 闇€瑕佷汉宸ュ鏍?/td> | 猸?/td> |
| 澶嶅埗鍒版柊琛ㄦ牸 | 淇濈暀鍘熷鏁版嵁 | 猸愨瓙 |
鈥?strong>鈥嬸煈?閲嶇偣鎿嶄綔锛氣€?/strong>鈥?/p>
- 鍕鹃€?鏁版嵁鍖呭惈鏍囬"锛堜笉鐒朵細鎶婃爣棰樺綋鏁版嵁鍒犱簡锛?/li>
- 鎸変綇鈥?strong>鈥婼hift閿€?/strong>鈥嬪閫夐渶瑕佸幓閲嶇殑鍒?/li>
- 鐐瑰嚮纭畾鍓嶆繁鍚镐竴鍙ｆ皵鈥斺€斿洜涓鸿繖涓€鎸変笅鍘伙紝鍙兘灏辨嫰鏁戜簡浣犱笁灏忔椂鐨勫伐浣滈噺锛?/li>
锛堟摝姹楋級鍒棶鎴戞€庝箞鐭ラ亾瑕佹繁鍚告皵鐨勶紝閮芥槸琛€娉暀璁?..
绗笁姝ワ細鎺掑簭鎶€宸э紝璁╂暟鎹細鎺掗槦锛?/h3>
浣犱互涓哄垹瀹岄噸澶嶅氨瀹屼簨浜嗭紵Too young锛侊紙鎽囨墜鎸囷級鐪熸鐨勯珮鎵嬭繕瑕佽鏁版嵁涔栦箹鎺掗槦锛?/p>
璇曡瘯杩欎釜缁勫悎鎷筹細
- 閫変腑澶勭悊濂界殑鏁版嵁鍖哄煙
- 鎸夆€?strong>鈥婣lt+D+S鈥?/strong>鈥嬫墦寮€鎺掑簭瀵硅瘽妗?/li>
- 鍦?涓昏鍏抽敭瀛?閫夎鎺掑簭鐨勫垪
- 绁炲鎿嶄綔锛氬湪"娆″簭"閲岄€?鑷畾涔夊簭鍒?鈫掕緭鍏ヤ綘鎯宠鐨勭壒娈婃帓搴忚鍒?/li>
鈥?strong>鈥嬧殸锔?琛€娉彁閱掞細鈥?/strong>鈥?br/> 鍗冧竾鍒墜璐辩偣"鎵╁睍閫夊畾鍖哄煙"锛佺壒鍒槸褰撲綘鏈夊叧鑱旀暟鎹殑鏃跺€欙紝杩欎釜閫夐」灏卞儚鎷嗙偢寮圭殑绾㈣摑绾匡紝閫夐敊灏变細瀵艰嚧鍏朵粬鍒楃殑鏁版嵁瀵逛笉涓婂彿锛侊紙鍒棶鎴戞€庝箞鐭ラ亾鐨?..锛?/p>
锛堟憯鏉瓙锛夎繖浜涘潙鎴戝府浣犺俯杩囦簡锛?/h3>
- 鈥?strong>鈥嬫棩鏈熸牸寮忊€?/strong>鈥嬫潃鍗冨垁锛氱湅鐫€鍍忔棩鏈熺殑鏁版嵁鍙兘鏄枃鏈牸寮忥紝鎺掑簭浼氫贡濂楋紒閫変腑鍒楁寜鈥?strong>鈥婥trl+1鈥?/strong>鈥嬫鏌ユ牸寮?/li>
- 鈥?strong>鈥嬮殣钘忚鈥?/strong>鈥嬬殑闄烽槺锛氳寰楀厛鍙栨秷鎵€鏈夐殣钘忚锛堚€?strong>鈥婥trl+Shift+9鈥?/strong>鈥嬶級锛屼笉鐒跺彲鑳芥紡鍒犻噸澶嶉」
- 鈥?strong>鈥嬮€氶厤绗︹€?/strong>鈥嬫悶浜嬫儏锛氭暟鎹噷濡傛灉甯︽槦鍙?鎴栭棶鍙?锛岀瓫閫夋椂浼氬嚭骞鸿浘瀛愶紝璁板緱鐢ㄢ€?strong>鈥媬鈥?/strong>鈥嬬鍙疯浆涔?/li>
涓汉绉佽揣鏃堕棿
锛堝枬鍙ｆ按锛夎鐐规帍蹇冪獫瀛愮殑璇濆惂銆傚緢澶氫汉瑙夊緱Excel鍘婚噸鎺掑簭灏辨槸涓妧鏈椿锛屾垜鍊掕寰楄繖鐜╂剰鍎跨壒鍒儚鍨冨溇鍒嗙被鈥斺€斺€?strong>鈥嬪叧閿笉鏄€庝箞鎵旓紝鑰屾槸鍏堝浼氭€庝箞鍒嗏€?/strong>鈥嬨€傦紙鎷嶅ぇ鑵匡級浣犱滑鍙戠幇娌★紵閭ｄ簺鐪熸鐢ㄥ緱濂紼xcel鐨勪汉锛屽仛浜嬮兘鐗瑰埆鏈夋潯鐞嗭紒
鏈€鍚庨€佸ぇ瀹跺彞璇濓細鏁版嵁鏁寸悊杩欎簨鍚э紝灏辫窡鏀舵嬀鎴块棿浼肩殑銆備綘鐪嬬潃鑰佺帇鎿嶄綔琛屼簯娴佹按锛屽叾瀹炰汉瀹朵篃灏辨槸姣斾綘澶氱煡閬撳嚑涓揩鎹烽敭銆傛妸杩欎笁鐐圭粌鐔熶簡锛屼笅涓湀鍋氭姤琛ㄧ粷瀵硅兘璁╅瀵肩溂鍓嶄竴浜紒锛堟簻浜嗘簻浜嗭級
本文由嘻道妙招独家原创，未经允许，严禁转载