Excel Magic Trick 683: 3 AND criteria & 3rd AND has OR criteria -- Add, Count & Conditional Format
Loading...
2,604
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (9)
-
You are welcome!!
-
Thanks being v usefulll
Loading...
Hi Mike
Can we do the same construct above (i.e AND, AND & OR) Criteria in anvanced filter?
emailuznow 1 year ago
Yes:
AND criteria goes on the same line (row), even if you have to repeat field names
OR criteria goes on separate lines (rows)
See this video:
Highline Excel Class 19: Advanced Filter Extract Data 9 Examples
The Key is that if you have three AND and third AND is an OR, list the first two AND's on two lines (rows) and the third one should have the first OR one line 1 (row 1) and the second OR is on line 2 (row 2). The video has an example just like your question.
ExcelIsFun 1 year ago
Great stuff... Really interesting and well presented. Keep em coming :-)
fishmanboy 1 year ago
You got it!
I already have the next 350 videos planned out (plus another 100 random ones that will pop up in-between the planned ones). It just takes so long to produce and post each video that I can only get to about 5 - 10 per week...
ExcelIsFun 1 year ago
maybe others asked this but i'm interested... how do you record your excel window?
iamipula 1 year ago
A Progarm called Camtasia.
ExcelIsFun 1 year ago