lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this
I understood all the above but what I do not understand, when I use a regular filter to filter Country to USA and UK and when I use filter to filter Quarter to Q4 and Q1. How that filter is AND ? AND what and what? and Why the above filter is considered as OR?
source:
https://www.excel-easy.com/examples/advanced-filter.html
Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this
I understood all the above but what I do not understand, when I use a regular filter to filter Country to USA and UK and when I use filter to filter Quarter to Q4 and Q1. How that filter is AND ? AND what and what? and Why the above filter is considered as OR?
source:
https://www.excel-easy.com/examples/advanced-filter.html