3步搞定Excel关键数据保留一键筛选+精准提取技巧
鍝堝柦鍚勪綅琛ㄥ摜琛ㄥ锛佷粖澶╁挶浠鏉ヨ亰鑱奅xcel閲屾渶璁╀汉澶寸柤鐨勯棶棰樷€斺€斺€?strong>鈥嬮潰瀵规捣閲忔暟鎹紝鎬庝箞鍍忓ぇ娴锋崬閽堜竴鏍峰揩閫熸壘鍒板叧閿俊鎭紵鈥?/strong>鈥?鍒厡锛佹垜鏁㈡墦璧岋紝鐪嬪畬杩欑瘒浣犵粷瀵硅兘浠庡皬鐧界鍙樻暟鎹瓫閫夎揪浜猴紝杩炶€佹澘閮借澶镐綘鏁堢巼缈诲€嶏紒
涓€銆佷竴閿瓫閫夛細3绉掓壘鍒板叧閿暟鎹?/h3>
鈥?strong>鈥?涓哄暐鎴戠瓫閫夊畬鏁版嵁锛屽師琛ㄨ繕鏄贡涓冨叓绯熺殑锛?鈥?/strong>鈥?杩欓棶棰橀棶寰楀ソ锛佸挶浠厛鏉ヨВ鍐虫渶鍩虹鐨勭瓫閫夐毦棰樸€?/p>
鈥?strong>鈥嬫楠?锛氭縺娲讳綘鐨?鏁版嵁闆疯揪"鈥?/strong>鈥?br/> 鎸変綇閿洏涓婄殑 鈥?strong>鈥婥trl+Shift+L鈥?/strong>鈥嬶紙Windows锛夋垨鑰?鈥?strong>鈥婥ommand+Shift+F鈥?/strong>鈥嬶紙Mac锛夛紝鐬棿寮€鍚瓫閫夋ā寮忋€傚氨鍍忕粰琛ㄦ牸鎴翠笂浜嗛€忚鐪奸暅锛屾瘡涓爣棰樻爮閮戒細鍐掑嚭灏忕澶达紒
鈥?strong>鈥嬫楠?锛氬仛涓仾鏄庣殑"鏁版嵁鎹曟墜"鈥?/strong>鈥?br/> 涓句釜鏍楀瓙馃尠锛氳浠?00鏉¤鍗曢噷鎵惧嚭"鍗庡寳鍖轰笖閲戦锛?涓?鐨勮鍗曪細
- 鐐瑰嚮"鍦板尯"鍒楀皬绠ご鈫掑嬀閫?鍗庡寳"
- 鐐瑰嚮"閲戦"鍒楀皬绠ご鈫掓暟瀛楃瓫閫夆啋澶т簬鈫掕緭鍏?0000
鐬棿鍙墿浣犺鐨?榛勯噾鏁版嵁"锛?/li>
鈥?strong>鈥嬮伩鍧戞寚鍗楋細鈥?/strong>鈥?/p>
- 閬囧埌绛涢€変笉鍏紵鍏堟鏌ヨ〃鏍兼湁娌℃湁绌鸿/鍚堝苟鍗曞厓鏍?/li>
- 蹇嵎閿け鐏碉紵璇曡瘯鎸変袱娆trl+Shift+L閲嶆柊婵€娲?/li>
浜屻€佺簿鍑嗘彁鍙栵細鎶婃暟鎹?姒ㄥ嚭姹?
鈥?strong>鈥?绛涢€夊畬鐨勬暟鎹€庝箞鍗曠嫭淇濆瓨锛?鈥?/strong>鈥?杩欐墠鏄湡鍔熷か锛佹暀浣犱袱绉嶅繀鏉€鎶€锛?/p>
鈥?strong>鈥嬫柟娉旳锛氬鍒剁矘璐村ぇ娉曗€?/strong>鈥?/p>
- 閫変腑绛涢€夊悗鐨勬暟鎹?/li>
- 鎸変笅 鈥?strong>鈥婣lt+;鈥?/strong>鈥?閫変腑鍙鍗曞厓鏍硷紙杩欎釜绁炴搷浣滆兘閬垮紑闅愯棌琛岋紒锛?/li>
- Ctrl+C澶嶅埗鈫掓柊寤鸿〃鏍尖啋Ctrl+V绮樿创
鎼炲畾锛佸師琛ㄦ暟鎹鍙戞棤鎹焴
鈥?strong>鈥嬫柟娉旴锛氬嚱鏁伴粦绉戞妧鈥?/strong>鈥?br/> 鎯宠嚜鍔ㄦ姄鍙栫壒瀹氭暟鎹紵璇曡瘯杩欎釜涓囪兘鍏紡锛?/p>
excel澶嶅埗=FILTER(鍘熸暟鎹尯鍩? 鏉′欢1*鏉′欢2)
涓句釜瀹為檯妗堜緥锛氳鎻愬彇閿€鍞儴涓斾笟缁╋紴5涓囩殑鍛樺伐
excel澶嶅埗=FILTER(A2:D100, (B2:B100="閿€鍞儴")*(D2:D100>50000))
鐩存帴鐢熸垚鍔ㄦ€佹暟鎹〃锛屽師琛ㄦ洿鏂拌繖閲岃嚜鍔ㄥ彉锛?/p>
| 鈥?strong>鈥嬩紶缁熺瓫閫夆€?/strong>鈥?/th> | 鈥?strong>鈥婩ILTER鍑芥暟鈥?/strong>鈥?/th> |
|---|---|
| 闇€瑕佹墜鍔ㄦ搷浣?/td> | 鑷姩鏇存柊 |
| 鍙兘閬楁紡鏁版嵁 | 绮惧噯鍖归厤 |
| 閫傚悎涓€娆℃€т娇鐢?/td> | 閫傚悎闀挎湡璺熻釜 |
涓夈€佹暟鎹繚鐣欙細璁╁叧閿俊鎭?瀹夊钀芥埛"
鈥?strong>鈥?鎻愬彇瀹岀殑鏁版嵁鎬庝箞姘镐箙淇濆瓨锛?鈥?/strong>鈥?杩欓噷鏈変釜瓒呭疄鐢ㄧ殑瀵规瘮琛細
| 鈥?strong>鈥嬩繚瀛樻柟寮忊€?/strong>鈥?/th> | 鈥?strong>鈥嬮€傜敤鍦烘櫙鈥?/strong>鈥?/th> | 鈥?strong>鈥嬫敞鎰忎簨椤光€?/strong>鈥?/th> |
|---|---|---|
| 鏂板缓宸ヤ綔琛?/td> | 闇€瑕侀暱鏈熶繚鐣?/td> | 璁板緱閲嶅懡鍚嶉伩鍏嶆贩娣?/td> |
| 鍙﹀瓨涓篜DF | 闇€瑕佸彂閫佺粰棰嗗 | 浼氫涪澶卞彲缂栬緫鎬?/td> |
| 澶嶅埗鍒癙PT | 瑕佸仛姹囨姤灞曠ず | 寤鸿淇濈暀Excel婧愭枃浠跺浠?/td> |
| 浜戠鍚屾 | 澶氳澶囧崗浣?/td> | 娉ㄦ剰鏁版嵁鏉冮檺璁剧疆 |
鈥?strong>鈥嬩釜浜虹鎴跨绫嶏細鈥?/strong>鈥?/p>
- 閲嶈鏁版嵁寤鸿鐢?鈥?strong>鈥?Ctrl+S澶ф硶"鈥?/strong>鈥?姣忓ぉ淇濆瓨3娆?/li>
- 鎼炲鏉傛搷浣滃墠鍏堟寜 鈥?strong>鈥婥trl+Z鈥?/strong>鈥?璇曢敊锛屽埆闂垜鎬庝箞鐭ラ亾鐨?..
鍥涖€佽嚜闂嚜绛旂幆鑺?/h3>
鈥?strong>鈥婹锛氱瓫閫夊悗鍒犻櫎鍏朵粬鏁版嵁浼氬嚭閿欏悧锛熲€?/strong>鈥?br/> A锛氭墜鍒姈锛佸厛澶嶅埗绛涢€夌粨鏋滃埌鏂拌〃鍐嶅垹鍘熻〃锛屽惁鍒欏彲鑳借鍒犻噸瑕佹暟鎹€傚氨鍍忓仛楗垏鑿滐紝鎶婅鐨勮彍鍙舵斁纰楅噷鍐嶆墧鑿滄牴鍢泘
鈥?strong>鈥婹锛氭暟鎹噺澶ぇ鍗￠】鎬庝箞鍔烇紵鈥?/strong>鈥?br/> A锛氳瘯璇曡繖涓夋澘鏂э細
- 鍏虫帀鍏朵粬绋嬪簭閲婃斁鍐呭瓨
- 鎶婃枃浠跺彟瀛樹负.xlsb鏍煎紡锛堜綋绉缉灏?0%锛侊級
- 鐢ㄦ暟鎹€忚琛ㄤ唬鏇跨洿鎺ョ瓫閫?/li>
鏈€鍚庤鐐瑰ぇ瀹炶瘽
鐢ㄤ簡杩欎箞澶氬勾Excel锛屾垜鍙戠幇寰堝浜哄叾瀹炶涓や釜闂鍥颁綇锛氣€?strong>鈥嬩笉鏁㈣瘯閿欌€?/strong>鈥?鍜?鈥?strong>鈥嬬洸鐩拷姹傚鏉傛妧宸р€?/strong>鈥嬨€傚叾瀹炶浣忚繖涓夌偣灏辫锛?/p>
- 绛涢€夊墠鍏堝浠斤紙琛€娉暀璁紒锛?/li>
- 鑳界敤蹇嵎閿氨鍒偣榧犳爣
- 澶嶆潅闂鎷嗚В鎴愬皬姝ラ
涓嬫鑰佹澘鍐嶈浣犳壘鏁版嵁锛岀洿鎺ョ敥缁欎粬涓€涓瓫閫夊ソ鐨勮〃鏍硷紝璁板緱娣辫棌鍔熶笌鍚崀 瑕佹槸杩欑瘒鏁欑▼甯埌浣狅紝璧剁揣鎵撳紑Excel瀹炴搷璧锋潵锛屽厜鐪嬩笉缁冨亣鎶婂紡鍝燂紒
本文由嘻道妙招独家原创，未经允许，严禁转载