篩選的數據如何保持一致

① 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鈥濊緭鍏ユ嗭紝閫夋嫨浣犲嶅埗鐨勫垪鍚嶏紝榪欐牱緇撴灉闆嗗皢鍙鍖呮嫭浣犻渶瑕佺殑鍒椼