Just got finished my first week at my new job and I think they are really impressed with my Excel skills! Could not function in this new job without your videos, thanks so much for putting out so many useful tutorials to help novices like myself. You are one of the great sages of the internet.
Brilliant Mike! I literally just taught something similar to this for the filter function with AND logical tests! I learned from you, and I tell it to everyone who will listen!
Crtl-Enter keeps younin the same cell instead of moving you down one row by default. Crtl-Shift-Enter is used tor old school array formulas....But we don't talk about these much anymore.
Yes. The OR function is a scalar function. OR can only deliver a single answer. The include argument in the FILTER function needs an array of trues and false is that is the same size as the table. It is filtering. So OR Will never work because it can always only give a single answer.
Make your own data sets with Excel Formulas. I have a bunch of videos: ruclips.net/video/V4JciRG3ZqY/видео.html ruclips.net/video/MUIzMMTAHUE/видео.html Or go onto some of my other classes. Maybe the Advanced or Data Analysis classes. My home page lists some of my many classes: www.youtube.com/@excelisfun
Hi Mike Many thanks for this. But why did you do + at ruclips.net/video/mT0Er97zWHM/видео.html ? This is a spilled array formula, so a simple will suffice?
Crtl-Enter keeps you in the same cell instead of moving you down a row by default. Crtl-Shift-Enter is used for old school Array formulas, but we don't talk about these very much anymore.
The benefit of Ctrl + Enter is when you are entering something and you immediately want to do something to the cell like format or copy. Since if you hit Enter your cursor would go down and they you would have to click back up to accomplish the "something". In this exact formula I was not going to immediately to something to the cell so I did not need Ctrl + Enter. It is my habit so often because I anticipate that something will be wrong with formula and I will need to edit the formula in that cell. But in this case it adds no benefit.
![Natanael Cano - Amor Eterno [Official Video]](http://i.ytimg.com/vi/EO4prCs6WpM/mqdefault.jpg)
That's always been a frustration. Your "trick" with the OR function is a great alternative!!
ORtricksarefun : ) : )
Just got finished my first week at my new job and I think they are really impressed with my Excel skills! Could not function in this new job without your videos, thanks so much for putting out so many useful tutorials to help novices like myself. You are one of the great sages of the internet.
I am so glad that I can help!!!!
Helper columns are very useful and not used as much as they could/should.
That is really true!!!!
Thanks Mike, As I learned from you many years ago another possible option is Advanced filter.
It is fun that we have been hanging out for so long!!!! Advanced Filter is a great idea.
Mike Is the man ...every time Is fun time but a new opportunity to learn something useful
I am glad it is fun and useful for you!!!
Good Mike! These are the kind of tricks that you never know when you'll need them.
You are so right! And most people when they get to it say: Oooooo!
Brilliant Mike! I literally just taught something similar to this for the filter function with AND logical tests! I learned from you, and I tell it to everyone who will listen!
Awesome!!! We are all having fun with filter : ) : )
Great Video!! Dragging filter below was super cool!!✌😉
Glad you liked it, Teammate "People Like Us"!!!!!!
Thumbs up of course! Thank you for this OR trick 🙌. I also like advanced filter in such situations 🙂
That is a great idea!!! : ) Alt, A, Q ; )
you are best teacher, pls start teaching Python.
Thank you for your kind words : ) I do not know python, so I can't teach it : (
@@excelisfun oh thats ok, sorry for being demanding 😂
Thank you, Mike.
Just to note that "old school" Advanced Filter also makes the task solved
Yes, Advanced Filter is a great idea!!!
Awesome, as usual. Thanks Mike.
I'm not sure why, but I use Alt-A-C to clear all my filters.
I love it : ) : ) : )
Similar:
I use Alt, A, Q to open Advanced Filter...
Great magic trick Mike. 👌
Glad you like it, Nader!!!!!
Thank you so much amazing Mike for this EXCELlenvt video.
You are welcome, Fellow Teacher Syed Muzammil Mahasan Shahi!!!!!!
Thanks Mike. Epic video as usual my friend.
Yes, indeed my World Record Friend!!!!!! : ) : )
Crtl-Enter keeps younin the same cell instead of moving you down one row by default.
Crtl-Shift-Enter is used tor old school array formulas....But we don't talk about these much anymore.
Bam!!!! It is like you are writing Excel books, Matt : ) : ) : )
Thanks Mike!!
You are welcome, Chris M!!!!!!
nice trick :)
Glad it is nice in a double column OR way ; )
After long time...
It is always wonderful to boomerang back to the Team!!!!!
amazing!
Glad you like it!!!!
I did not like it, I Loved it, Mike! @@excelisfun
A Thursday night upload!
No night is a bad night to have fun with Excel, right? : )
Is there a reason to not use =OR() in the =FILTER() function, instead of the addition logic?
Yes. The OR function is a scalar function. OR can only deliver a single answer. The include argument in the FILTER function needs an array of trues and false is that is the same size as the table. It is filtering. So OR Will never work because it can always only give a single answer.
Function filter is magic...
It is. We are so glad that Microsoft finally gave it to us : )
Hey mike recently going through your beginners excel playlist everything is awesome but i want more data to practice.. What should I do
Make your own data sets with Excel Formulas. I have a bunch of videos:
ruclips.net/video/V4JciRG3ZqY/видео.html
ruclips.net/video/MUIzMMTAHUE/видео.html
Or go onto some of my other classes. Maybe the Advanced or Data Analysis classes. My home page lists some of my many classes:
www.youtube.com/@excelisfun
@@excelisfun thank you very much Mike
Hi Mike
Many thanks for this. But why did you do + at ruclips.net/video/mT0Er97zWHM/видео.html ? This is a spilled array formula, so a simple will suffice?
Crtl-Enter keeps you in the same cell instead of moving you down a row by default.
Crtl-Shift-Enter is used for old school Array formulas, but we don't talk about these very much anymore.
The benefit of Ctrl + Enter is when you are entering something and you immediately want to do something to the cell like format or copy. Since if you hit Enter your cursor would go down and they you would have to click back up to accomplish the "something". In this exact formula I was not going to immediately to something to the cell so I did not need Ctrl + Enter. It is my habit so often because I anticipate that something will be wrong with formula and I will need to edit the formula in that cell. But in this case it adds no benefit.
@excelisfun
Ah, I see! I have that "cursor moves down one cell on hitting Enter" default turned off in my Excel setup, as it annoys me!
Thanks Mike!!
You are welcome, Formula Guy John!!!!