筛选的数据如何保持一致

① excel𨱒′欢绛涢夋樉绀哄皬浜庣殑锛屾湁镄勬樉绀虹殑涓嶅规槸涓轰粈涔堬纻

1銆丣鍒楋细=LOOKUP(N25,{0;21;31;41;51;61;71;81;91;101;201;301;401;501;601;701;801;901;1001;2001;3001;4001;5001;6001;7001;8001;9001;10001},{"2000绉鍒";"3000绉鍒";"4000绉鍒";"5000绉鍒";"6000绉鍒";"7000绉鍒";"8000绉鍒";"9000绉鍒";"1涓囩Н鍒";"2涓囩Н鍒";"3涓囩Н鍒";"4涓囩Н鍒";"5涓囩Н鍒";"6涓囩Н鍒";"7涓囩Н鍒";"8涓囩Н鍒";"9涓囩Н鍒";"10涓囩Н鍒"})

鍓嶉溃链28灞傜骇锛屽悗闱㈡湁18灞傜骇锛岀淮搴︿笉涓镊淬

2銆并鍒楋细=LOOKUP(G25,{0;2001;3001;4001;5001;6001;7001;8001;9001;10001;20001;30001;40001;50001;60001;70001;80001;90001;100001;200001;300001;400001;500001;600001;700001;800001;900001;1000001;2000001;3000001;4000001;5000001;6000001;7000001;8000001;9000001;10000001},{"2000绉鍒";"3000绉鍒";"4000绉鍒";"5000绉鍒";"6000绉鍒";"7000绉鍒";"8000绉鍒";"9000绉鍒";"1涓囩Н鍒";"2涓囩Н鍒";"3涓囩Н鍒";"4涓囩Н鍒";"5涓囩Н鍒";"6涓囩Н鍒";"7涓囩Н鍒";"8涓囩Н鍒";"9涓囩Н鍒";"10涓囩Н鍒";"20涓囩Н鍒";"30涓囩Н鍒";"40涓囩Н鍒";"50涓囩Н鍒";"60涓囩Н鍒";"70涓囩Н鍒";"80涓囩Н鍒";"90涓囩Н鍒";"100涓囩Н鍒"})

鍓嶉溃链37灞傜骇锛屽悗闱㈡湁27灞傜骇锛屼袱镙风淮搴︿笉涓镊淬

3銆佽蜂缭鎸丩OOKUP镆ユ垒寮旷敤鍖哄烟镄勭淮搴︿竴镊达纴鎴栬呯洿鎺ュ皢瀵瑰簲鏁版嵁寤虹珛鍦ㄦ煇鍖哄烟锛屽侫2:B29锛岀劧钖庤緭鍏=LOOKUP(N25,A$2:B$29)

璇﹁侀梼锲剧ず渚

② 濡傛灉𨱍冲湪绛涢夊悗镄勮嫢骞插煎啀锷犱笂涓涓鐩稿悓镄勫硷纴镐庢牱镎崭綔锛

Excel 鏄瀛樻斁澶ч噺鏁版嵁镄勫湴鏂癸纴浣嗗畠鍙堜笉鏄涓涓扑笟镄勬暟鎹搴撱傜劧钥孍xcel 鐢ㄦ埛瀵规暟鎹镄勬搷浣滆佹眰鍗磋秺𨱒ヨ秺闱犺繎鏁版嵁搴撱傛瘆濡傜瓫阃夎繖浠朵簨钖э纴Excel 镄 AutoFilter 锷熻兘澶у氭暟浜洪兘浼氱敤锛屼篃璁歌缮浼氲嚜瀹氢箟涓涓嬶纴浣嗘槸𨱒′欢涓澶氾纴AutoFilter 锷熻兘灏卞簲浠树笉杩囨潵浜嗐备緥濡傦纴AutoFilter 镄勮嚜瀹氢箟鍙鏀鎸佷袱涓鍒ゆ柇寮忕殑Or 鎴朅nd鍏崇郴锛屽綋鎴戜滑鍦ㄥ憳宸ヨ〃閲屾煡镓锯滃紶涓夆濆拰钬沧潕锲涒濈殑淇℃伅镞讹纴杩樿兘鍙戞尌浣灭敤锛屽啀锷犱竴涓钬灭帇浜斺濆氨涓嶈屼简銆

鍦ㄦ暟鎹搴挞噷锛屾垜浠瀵规暟鎹杩涜岀瓫阃夌殑瑕佹眰鍙浠ラ氲繃鏋佸叾澶嶆潅镄凷QL 璇鍙ユ潵瀹炵幇锛屼絾鏄疎xcel 涓嶅儚Access锛屽苟娌℃湁涓扑笟镄勬煡璇㈡ā鍧楋纴涓嶈繃Excel 鎻愪緵镄 Advanced Filter 锷熻兘鍊掓槸鍜孲QL 璇鍙ユ寚瀹氱殑鍑嗗垯钬滃樊鍙𨰾颎濄傛牴鎹鎴戝湪宸ヤ綔涓镄勮傚疗锛屼娇鐢ㄨ繖涓锷熻兘杩樻槸闇瑕佸煿璁涓涓嬬殑锛岃佺湡姝ｇ悊瑙Advanced Filter 锷熻兘镄勫唴娑碉纴镓嶈兘鍦ㄥ勭悊鏁版嵁镞跺缑蹇冨簲镓嬶纴浜鍙楀畠镄勫ソ澶勚

Advanced Filter 鍦ㄧ瓫阃夋浔浠舵瘆杈冨嶆潅镞跺氨鍙浠ユ樉绀鸿韩镓嬩简銆备娇鐢ˋdvanced Filter 锷熻兘镞讹纴鍑嗗垯涓嶆槸鍦ㄥ硅瘽妗嗛噷杈揿叆镄勶纴钥屾槸鍦ㄥ崟鍏冩牸閲岋纴杩欐牱鍑嗗垯灏卞彲澶氩彲灏戯纴澶уぇ澧炲姞浜嗙伒娲绘с傛垜浠杈揿叆鍑嗗垯镄勫崟鍏冩牸琚绉颁负钬淐riteria range钬濓纴 Advanced Filter 锷熻兘鍙瑕佺煡阆撯淐riteria range钬濆湪鍝閲屽氨琛屼简銆

Advanced Filter 锷熻兘瑕侀厤缃镄勫弬鏁版湁5椤广
List Range锛屼篃灏辨槸铡熷嬫暟鎹銆傝繖鍧楁暟鎹瑕佹湁鍒楀ご锛岀被浼间簬鏁版嵁搴撹〃镄勫瓧娈靛悕銆傚师濮嬫暟鎹鍦ㄥ伐浣滆〃閲岀殑浣岖疆娌℃湁浠涔堢壒鍒瑙勫畾锛屼笉闇瑕佷粠绗涓琛岀涓鍒楀紑濮嬶纴鍙瑕佽繖鍧楁暟鎹鐪嬩笂铡诲儚涓琛ㄧ殑镙峰瓙锛屾湁鍒楀ご(瀛楁靛悕)鍜屾暟鎹銆
Criteria Range锛屽嗳鍒椤尯锘熴傚嗳鍒椤尯锘熶篃闇瑕佸垪澶达纴琛ㄧず瀵瑰摢鍒楋纴涔熷氨鏄瀵瑰摢涓瀛楁垫寜鍑嗗垯杩涜岀瓫阃夈傚嗳鍒椤尯锘熺殑鍒楁暟涓嶉渶瑕佸拰铡熷嬫暟鎹镄勫垪鏁颁竴镙凤纴鍙瑕佹妸浣滀负鍑嗗垯镄勫垪鏀惧湪杩欓噷灏辫屼简銆傛瘆濡傦纴铡熷嬫暟鎹链塈D锛屽㈡埛锛岄噾棰濓纴阌鍞浜哄憳锛屾椂闂翠簲鍒楋纴鎴戜滑镄勪换锷℃槸鎶婃煇浜涢攒鍞锻桦湪镆愭垫椂闂寸殑阌鍞璁板綍鏄剧ず鍑烘潵锛屾垜浠镄勫嗳鍒椤尯锘熷氨鍙闇瑕佲滈攒鍞浜哄憳钬濆拰钬沧椂闂粹濅袱鍒椼傚傛灉瀵笋QL 璇鍙ュ緢浜呜В锛屽氨鐭ラ亾鍑嗗垯鍖哄烟镄勪綔鐢ㄧ浉褰扑簬
where (阌鍞浜哄憳=value1 OR 阌鍞浜哄憳=value2) AND (镞堕棿=value3)鍑嗗垯鍖哄烟鍦ㄥ伐浣滆〃涓婃斁缃镄勪綅缃骞舵病链夌壒鍒瑕佹眰锛屽彧瑕佷笉鍜屽师濮嬫暟鎹瑕嗙洊灏卞ソ锛屾垜姣旇缉锽沧㈠拰铡熷嬫暟鎹闅斿紑鍑犲垪宸﹀彸骞舵帓鏀俱傚垏璁帮纴鍑嗗垯镄勫垪钖崭竴瀹氲佸拰铡熷嬫暟鎹镄勫垪钖崭竴镊达纴澶氢釜绌烘牸閮戒笉琛岋纴钖﹀垯灏辨槸涓や釜瀛楁靛悕浜嗐傛湁镞跺欙纴杩欐槸 Advanced Filter 锷熻兘澶辫触镄勫师锲犮
灏卞湴杩囨护杩樻槸澶嶅埗鍒版柊镄勫湴鏂广傚傛灉鍦╒BA浠ｇ爜閲岃皟鐢 AdvancedFilter 鏂规硶锛岃繖閲岀殑鍊煎氨鏄疉ction:=xlFilterCopy 鎴 Action:=xlFilterInPlace
濡傛灉阃夋嫨浜嗗嶅埗鍒版柊鍦版柟锛岄偅涔堣缮瑕佹彁渚涘笇链涘嶅埗鍒扮殑鍖哄烟銆
杩囨护镞舵槸钖﹀彧淇濈暀鍞涓镄勮板綍銆 Unique:=True 鎴 False銆
寰杞链変釜缃戦〉Examples of complex criteria 璇︾粏璁蹭简澶嶆潅鍑嗗垯镄勮剧疆銆傚叾瀹炰娇鐢ˋdvanced Filter 锷熻兘镄勫叧阌灏辨槸濡备綍鍐椤嗳鍒椤尯锘熴

鎴戣繖閲屽熺敤涓涓嫔井杞镄勭ず渚嬫暟鎹锛岀◢浣沧敼锷锛屾垜璇翠简鎴戝枩娆㈠师濮嬫暟鎹鍜屽嗳鍒欐暟鎹宸﹀彸骞舵帓鏀俱(铡熷嬬殑绀轰緥鏁版嵁鏄涓娄笅骞舵帓鏀剧殑銆)

A B C D E F G
1 Type Salesperson Sales Type Salesperson Sales
2 Beverages Suyama $5122
3 Meat Davolio $450
4 proce Buchanan $6328
5 Proce Davolio $6544

涓銆佷竴涓鍒楅噷涓娄笅鍐椤氢釜鏁版嵁

杩欓噷镄勫垪鎸囩殑鏄鍑嗗垯鍖哄烟镄勫垪銆傚湪钖屼竴涓鍒楀ご涓嬶纴鍑虹幇鍦ㄤ笉钖岃岀殑鏁版嵁琛ㄧずOR 镄勫叧绯汇傛瘆濡傚湪F2 濉涓娾淒avolio钬濓纴鍦‵3 濉涓娾淏uchanan钬濓纴骞舵寚瀹氩嗳鍒椤尯锘熶负 (F1:F3)锛岃〃绀烘妸鍖呭惈钬淒avolio钬濇垨钬淏uchanan钬濈殑琛屾垒鍑烘潵銆 鐩稿綋浜岙QL 璇鍙ョ殑 where Salesperson = "Davolio" OR Salesperson = "Buchanan"銆

娉ㄦ剰锛氱┖锏界殑鍗曞厓镙艰〃绀哄叏閮ㄨ板綍銆傛瘆濡傦纴涓娄緥涓璅4 鏄绌虹槠镄勶纴鎸囧畾鍑嗗垯鍖哄烟涓(F1:F4) 浼氲繑锲炴墍链夎板綍銆

浜屻佹浔浠舵潵镊澶氢釜鍒楀苟涓旀墍链夋浔浠惰佷负鐪

锅氭硶灏辨槸鍦ㄥ悓涓琛屼笉钖岀殑鍒楅噷杈揿叆𨱒′欢銆傚嚭鐜板湪钖屼竴琛岀殑鏁版嵁涔嬮棿鏄疉ND 镄勫叧绯伙纴鍑虹幇鍦ㄥ悓涓鍒楃殑鏁版嵁涔嬮棿鏄疧R 镄勫叧绯汇

渚嫔傦纴瑕佹垒绫诲瀷涓衡淧roce钬濓纴骞朵笖閲戦濆ぇ浜$1000镄勮板綍锛屽氨鍦‥2 杈揿叆钬淧roce钬濓纴鍦℅2 杈揿叆钬>1000钬濓纴骞舵寚瀹氩嗳鍒椤尯锘熶负(E1:G2)銆傜浉褰扑簬SQL 璇鍙ョ殑 where Type = "Proce" AND Sales > 1000銆

鎴戜滑杩欓噷镄勬浔浠跺嚭鐜颁简钬>1000钬濓纴濡傛灉娌℃湁鎸囧畾姣旇缉杩愮畻绗︼纴榛樿ゆ槸绛変簬镄勫叧绯(=)銆傚傛灉瑕佹槑纭鐢ㄧ瓑浜庡彿𨱒ユ寚瀹氱浉绛夋瘆杈冿纴鍦ㄥ崟鍏冩牸閲岃緭鍏 =''=entry''銆备笉绠℃槸鏂囨湰杩樻槸鏁板兼瘆杈冿纴閮界敤杩欑嶅瓧绗︿覆鏂瑰纺琛ㄧず銆俥ntry 鏄瑕佹瘆杈幂殑鏂囨湰鎴栨暟鍊笺备箣镓浠ョ敤杩欑嶅舰寮忥纴鏄锲犱负鍦‥xcel 閲岀瓑浜庡彿(=)鐢ㄦ潵琛ㄧず钖庨溃杈揿叆镄勫唴瀹硅佸綋鍏寮忓勭悊銆

渚嫔傦纴鎴戜滑杈揿叆="=Davolio"锛孍xcel 鏄剧ず镄勬槸 =Davolio銆傝緭鍏="=3000"锛屾樉绀 =3000銆

涓夈佹浔浠舵潵镊澶氢釜鍒椾换镒忔浔浠朵负鐪

Boolean logic: (Type = "Proce" OR Salesperson = "Davolio")

浠庝笂闱涓や釜渚嫔瓙鐪嫔埌锛孉dvanced Filter 锷熻兘钖屼竴琛岀殑鍑嗗垯涔嬮棿鏄疉ND 镄勫叧绯伙纴钖屼竴鍒楃殑鍑嗗垯涔嬮棿鏄疧R 镄勫叧绯汇傚叾瀹烇纴鍙瑕佹槸鍑虹幇鍦ㄤ笉钖岃岋纴鍑嗗垯涔嬮棿灏辨槸OR 镄勫叧绯汇傚傛灉鎴戜滑瑕佷互澶氢釜瀛楁典负𨱒′欢锛屼换镒忔浔浠舵垚绔嫔氨鍙浠ワ纴鍙瑕佸湪瀵瑰簲镄勫垪钖崭笅锛屽湪涓嶅悓琛岃緭鍏ユ浔浠跺氨鍙浠ャ

渚嫔傦纴鎴戜滑瑕佹煡镓剧被鍨嬫槸钬淧roce钬濇垨阌鍞浜哄憳鏄钬淒avolio钬濈殑璁板綍銆傚氨鍦‥2 杈揿叆钬淧roce钬濓纴鍦‵3 杈揿叆钬淒avolio钬濓纴骞舵寚瀹氩嗳鍒椤尯锘熶负(E1:F3)銆傜浉褰扑簬SQL 璇鍙ョ殑 where Type = "Proce" OR Salesperson = "Davolio"銆

锲涖佸氩楀嗳鍒欙纴姣忓楀嗳鍒欓兘鍖呭惈浜嗗氩垪涓烘浔浠

鐩存帴鐪嬭佹眰钖э纴镓惧嚭Davolio 澶т簬3000 缇庡厓镄勯攒鍞璁板綍锛屾垨钥呮垒鍑筑uchanan 澶т簬1500 缇庡厓镄勯攒鍞璁板綍銆傜敤SQL 璇鍙ヨ〃杈捐佹眰灏辨槸 where (Salesperson = "Davolio" AND Sales >3000) OR (Salesperson = "Buchanan" AND Sales > 1500)銆

钬淒avolio 澶т簬3000 缇庡厓镄勯攒鍞璁板綍钬濈畻鏄涓濂楀嗳鍒欙纴钬淏uchanan 澶т簬1500 缇庡厓镄勯攒鍞璁板綍钬濇槸鍙︿竴濂楀嗳鍒欍备袱濂楀嗳鍒欎箣闂存槸OR 镄勫叧绯伙纴闾ｄ箞涓ゅ楀嗳鍒欐槸鍦ㄤ笉钖岃岃緭鍏ョ殑銆傚啀鐪嬫疮濂楀嗳鍒椤唴閮锛岃繖涓ゅ楀嗳鍒欑殑瑕佹眰鏄涓镙风殑锛屾垜浠鍙瑕佸垎鏋愪竴濂楀氨鍙浠ヤ简銆傗淒avolio 澶т簬3000 缇庡厓镄勯攒鍞璁板綍钬濈敤鍒颁袱涓瀛楁碉纴涓よ呮槸AND 镄勫叧绯伙纴涔熷氨鏄璇粹=Davolio钬濆拰钬>3000钬 瑕佸嚭鐜板湪钖屼竴琛屻傛垜浠鍦‵2 杈揿叆钬淒avolio钬濓纴鍦℅2 杈揿叆钬>3000钬濄傚悓鐞嗭纴鍦‵3 杈揿叆钬淏uchanan钬濓纴鍦℅3 杈揿叆钬>1500钬濄傛渶钖庯纴鎸囧畾鍑嗗垯鍖哄烟涓 (E1:G3)銆

浜斻佸氩楀嗳鍒欙纴姣忓楀嗳鍒欓兘浠ュ悓涓鍒椾负𨱒′欢

杩欓噷镄勮佹眰鏄锛屾垒鍑洪攒鍞棰濆ぇ浜6000 骞朵笖灏忎簬6500 镄勮板綍锛屾垨钥呮垒鍑洪攒鍞棰濆皬浜500 镄勮板綍銆傜敤SQL 璇鍙ヨ〃杈捐佹眰灏辨槸 where (Sales > 6000 AND Sales < 6500 ) OR (Sales < 500)銆

瀵逛簬钬滈攒鍞棰濆ぇ浜6000 骞朵笖灏忎簬6500钬濊繖绉崭竴涓瀛楁靛悓镞惰佹弧瓒充袱涓𨱒′欢镄勭瓫阃夎佹眰锛屾垜浠瀵逛簬杩欎釜瀛楁靛氨瑕佸啀锷犱竴涓钖屾牱镄勫垪澶翠简銆傚墠闱浜岀殑渚嫔瓙鏄涓や釜涓嶅悓镄勫瓧娈靛悓镞舵弧瓒虫浔浠讹纴杩欎釜渚嫔瓙鏄钖屼竴涓瀛楁靛悓镞舵弧瓒充袱涓𨱒′欢銆

A B C D E F G H
1 Type Salesperson Sales Type Salesperson Sales Sales
2 Beverages Suyama $5122 >6000 <6500
3 Meat Davolio $450 <500
4 proce Buchanan $6328
5 Proce Davolio $6544

𨱒′欢琛ㄧず鏂规硶濡备笂琛ㄦ墍绀猴纴骞舵寚瀹氩嗳鍒椤尯锘熶负(G1:H3)銆

鍏銆佹枃链涓閮ㄥ垎瀛楃﹀尮閰嶏纴鍗冲瓧绗︿覆鏂囨湰涓锅氭ā绯婃煡璇

杈揿叆鍑嗗垯镞朵笉瑕佺敤绛変簬鍙 (=)锛岀洿鎺ヨ緭鍏ヨ佹煡镓剧殑閮ㄥ垎瀛楃︼纴Excel 浼氩垪鍑轰互杩欎簺瀛楃﹀紑澶寸殑镓链夎板綍銆傛瘆濡傦纴杈揿叆 Dav 浣滀负鍑嗗垯锛孍xcel 浼氭垒鍑衡淒avolio钬濓纴钬淒avid钬濆拰钬淒avis钬濈瓑杩欐牱浠モ淒av钬濆紑澶磋板綍銆

杩樻湁绉嶆柟娉曟槸鐢ㄩ氶厤绗* 鎴栬?锛岃繖镙峰瓧绗﹀嚭鐜板湪浠涔埚湴鏂归兘鍙浠ャ

灏忔妧宸э细~ (tilde)绗﹀彿鐢ㄦ潵镓* 銆?锛屾垨钥厏銆备緥濡傦纴fy91~? 镓惧嚭 "fy91?"銆

涓冦佷互鍏寮忕殑杩斿洖鍊间綔涓哄嗳鍒

鍦ㄥ嗳鍒欓噷涔熷彲浠ュ埄鐢ㄥ叕寮忚繑锲炲硷纴浣呜佽颁綇浠ヤ笅閲嶈佺殑鍑犵偣锛

鍏寮忕殑杩斿洖鍊煎繀椤绘槸 TRUE 鎴 FALSE銆
鎸夋ｅ父鏂瑰纺杈揿叆鍏寮忋
鍑嗗垯浣跨敤鍏寮忕殑鍒椾笉瑕佺敤铡熷嬫暟鎹涓镄勫垪澶(瀛楁靛悕)锛屾垨钥呬缭鎸佸垪钖崭负绌虹槠锛屾垨钥呭畾涔変竴涓闱炲师濮嬫暟鎹涓鍒楀悕镄勬柊鍒楀悕銆
浣滀负鍑嗗垯镄勫叕寮忓繀椤讳娇鐢ㄥ崟鍏冩牸镄勭浉瀵瑰紩鐢ㄦ潵鎸囧悜鏁版嵁鍖虹涓琛屼腑瀵瑰簲镄勫崟鍏冩牸銆
鍏寮忛噷镄勬墍链夊叾瀹冨紩鐢ㄥ繀椤讳娇鐢ㄧ粷瀵瑰紩鐢锛屽嵆鐢$绗﹀彿锛屾瘆濡$A$1銆
鐪嬩袱涓渚嫔瓙:

1銆佹垒鍑洪噾棰濆ぇ浜庡钩鍧囧肩殑璁板綍

A B C D E F G H
1 Type Salesperson Sales Type Salesperson Sales Average
2 Beverages Suyama $5122 =C2>AVERAGE($C$2:$C$5)
3 Meat Davolio $450
4 proce Buchanan $6328
5 Proce Davolio $6544

H1 鏄鏂板畾涔夌殑涓涓鍒楀悕钬淎verage钬濓纴C2 鏄鐩稿瑰紩鐢锛岃〃绀鸿佽繃婊ょ殑钬沦ales钬濇爮锛屽嵆C 镙忎腑绗涓琛屾暟鎹镓鍦ㄥ崟鍏冩牸锛孉VERAGE($C$2:$C$5) 閲岀殑鍙傛暟閮芥槸缁濆瑰紩鐢ㄣ傛寚瀹氩嗳鍒椤尯锘熶负 (H1:H2)銆

2銆佸瓧绗︿覆绛涢夋椂澶у皬鍐欐晱镒

Advanced Filter 锷熻兘鍦ㄧ瓫阃夋椂锛屽瓧姣嶅ぇ灏忓啓鏄涓嶅垎镄勚傛瘆濡傚湪鍓嶉溃绗浜屼緥涓锛屸淧roce钬濅负𨱒′欢锛屼细镓惧嚭绫诲瀷涓衡淧roce钬濆拰钬减roce钬濈殑璁板綍銆傚傛灉鎴戜滑寮哄埗瑕佹眰澶у皬鍐欐晱镒燂纴鍙镓惧嚭绫诲瀷涓衡淧roce钬濈殑璁板綍锛屽氨瑕佸埄鐢ㄥ叕寮忓府蹇欎简銆

A B C D E F G H
1 Type Salesperson Sales Type Salesperson Sales ExactMatch
2 Beverages Suyama $5122 =EXACT(A2, "Proce")
3 Meat Davolio $450
4 proce Buchanan $6328
5 Proce Davolio $6544

H1 鏄鏂板畾涔夌殑涓涓鍒楀悕钬淓xactMatch钬濓纴A2 鏄鐩稿瑰紩鐢锛岃〃绀鸿佽繃婊ょ殑钬淭ype钬濇爮锛屽嵆A 镙忎腑鏁版嵁鍖虹涓琛岀殑鍗曞厓镙硷纴鎸囧畾鍑嗗垯鍖哄烟涓 (H1:H2)銆

闄勫綍锛

鎶婂嗳鍒椤尯锘熷懡钖崭负 Criteria锛屽师濮嬫暟鎹鍖哄烟锻藉悕涓 Database锛岃佸嶅埗鍒扮殑鍖哄烟锻藉悕涓篍xtract锛岃繖镙禀dvanced Filter 锷熻兘瀵硅瘽妗嗙殑鍑犱釜鍙傛暟浼氲嚜锷ㄥ～涓娿

濡傛灉瑕佹妸杩囨护钖庣殑缁撴灉闆嗗嶅埗鍒版柊镄勫湴鏂癸纴鍙浠ュ彧澶嶅埗鎸囧畾镄勫垪銆傚厛鎶婇渶瑕佺殑鍒楀悕澶嶅埗鍒板嗳澶囨斁鏁版嵁镄勫尯锘熺殑绗涓琛岋纴鍦ˋdvanced Filter 锷熻兘瀵硅瘽妗嗙殑钬淐opy to钬濊緭鍏ユ嗭纴阃夋嫨浣犲嶅埗镄勫垪钖嶏纴杩欐牱缁撴灉闆嗗皢鍙鍖呮嫭浣犻渶瑕佺殑鍒椼