Respuesta :
Data can be filtered in the AutoFilter dialog box if they meet all the apply.
- two criteria based on a âwhenâ comparison
- one criterion based on a âwhenâ comparison
- two criteria based on an âandâ comparison
- one criterion based on an âandâ comparison
- two criteria based on an âorâ comparison
- one criterion based on an âorâ comparison
Explanation:
Based on end user usage the auto file dial box meets the requirements. All combinations will work on  to do auto filer in the selected data or whole data.
If end user using the MS-excel on the current work sheet. Â âWhenâ is used for with one or two criteria with some logical operations. Mostly one criteria based is used.
âANDâ logical operator is used to more the one criteria or single criteria. Same way âORâ also it has can be used with one or two criteria.