How to set the filter conditions of excel table How to set the filter conditions of excel table

Select the columns to filter by multiple criteria.

Please click to enter a picture description.

Then click the data menu option at the top.

Please click to enter a picture description.

three

Then select the filter.

Please click to enter a picture description.

four

Then click on the small inverted triangle at the top.

Please click to enter a picture description.

five

Select Digital Filter-Custom Filter in the pop-up box.

Please click to enter a picture description.

six

Set the first condition: greater than 60 and the second condition less than 70.

Please click to enter a picture description.

seven

Then click OK to view the data between 60 and 70.