Applying Advanced Filters

  1. 灏囪绡╅伕鐨勮│绠楄〃绡勫湇涔嬫瑒铏熻瑁藉埌瑭︾畻琛ㄧ殑绌虹櫧鍗濉婏紝鐒跺緦鍦ㄦ瑒铏熶笅鏂圭殑鍒椾腑杓稿叆绡╅伕姊濅欢銆傚垪涓按骞虫柟鍚戞帓搴忕殑璩囨枡灏囩附浠ラ倧杓铏 AND 鐩搁g祼锛岃屾瑒涓瀭鐩存柟鍚戞帓搴忕殑璩囨枡灏囩附浠ラ倧杓铏 OR 鐩搁g祼銆

  2. Once you have created a filter matrix, select the sheet ranges to be filtered. Open the Advanced Filter dialog by choosing Data - More Filters - Advanced Filter, and define the filter conditions.

  3. Then click OK, and you will see that only the rows from the original sheet whose contents have met the search criteria are still visible. All other rows are temporarily hidden and can be made to reappear with the Format - Rows - Show command.

Example

杓夊叆涓鍊嬪寘鍚ぇ閲忚硣鏂欐鐩殑瑭︾畻琛ㄣ傛垜鍊戜娇鐢ㄧ殑鏄竴鍊嬭櫅妲嬬殑鐕熸キ椤鏂囦欢锛屾偍涔熷彲浠ラ毃鎰忎娇鐢ㄤ换浣曞叾浠栨枃浠躲傝┎鏂囦欢鍏锋湁浠ヤ笅鐗堥潰閰嶇疆锛

A

B

C

D

E

1

妯欐簴

鍟嗗嫏

璞彲

濂楁埧

2

涓鏈

125600

200500

240000

170000

3

浜屾湀

160000

180300

362000

220000

4

涓夋湀

170000

绛夌瓑...


渚嬪锛岃珛瑜囪=鍏у惈妯欓鐐鸿硣鏂欐瑒浣嶅悕绋辩殑鍒 1 鍒板垪 20銆傝几鍏ヤ互 OR 閫g祼鐨勭閬告浠惰嚦鍒 21銆22锛屼互姝ら鎺ㄣ傛绡勫湇鍙兘濡備笅鎵绀猴細

A

B

C

D

E

20

妯欐簴

鍟嗗嫏

璞彲

濂楁埧

21

涓鏈

22

<160000


Specify that only rows which either have the value January in the Month cells OR a value of under 160000 in the Standard cells will be displayed.

Choose Data - More Filters - Advanced Filter, and then select the range A20:E22. After you click OK, only the filtered rows will be displayed. The other rows will be hidden from view.

Please support us!