About auto filter
Use filters to temporarily cover many of the facts inside a table, so you can target the data you should see.Choose a situation and then decide on or enter requirements. Click on the And button to combine criteria (which is, two or more standards that ought to both equally be fulfilled), as well as Or button to involve just one of numerous problems