For a long time I was a big fan/user of Advanced Filter and SUMPRODUCT for "complex" filtering. BUT I haven't pressed Alt,A,Q since Fall 2018!!! Kinda like getting a new mattress--how soon we forget the old one!
Thanks for the video, Mike. Was great to see someone using advanced filter; it is one of my favourites from way back when, and I still use it sometimes. I do hope that the excel team don't deprecate it in favour of =FILTER!
Very nice to see the "old" Advanced Filter also working. Although the newborn FILTER gets a lot of attention nowadays worldwide, the old tools still do their job! Nice to see you respect these old methods as well ....😉
Amazing as always Mike. You are the best. I usually replace the + or condition with (ISNUMBER(XMATCH(E5:E14,$L$18:$L$19))) if I have to find multiple values. =FILTER(B5:F14 ,( (B5:B14>=H18)*(B5:B14
Thank you so much fort the kind token : ) : ) : ) : ) I am still down in California taking care of my Mom. Thank you for the well wishes and support, Ankursharma!!!!
Hi there, Cool video but I have a question, what is the difference between this kind of filter and the common kind of filter, the automatic ones. If I put an automatic filter I can do the same, right? Or not?
For a long time I was a big fan/user of Advanced Filter and SUMPRODUCT for "complex" filtering. BUT I haven't pressed Alt,A,Q since Fall 2018!!! Kinda like getting a new mattress--how soon we forget the old one!
Mike cada video tuyo es una enseñanza completa, un contenido invaluable. Gracias por seguir. Un abrazo fuerte.
Straight to the point. No nonsense! That's Mike! Thank you!
Thanks for the video, Mike. Was great to see someone using advanced filter; it is one of my favourites from way back when, and I still use it sometimes. I do hope that the excel team don't deprecate it in favour of =FILTER!
You are the best Mike
Thanks for sharing 😊
Very nice to see the "old" Advanced Filter also working. Although the newborn FILTER gets a lot of attention nowadays worldwide, the old tools still do their job! Nice to see you respect these old methods as well ....😉
What a teacher!
Glad to help!!
Great as always.Thanks Mike
Thank you Mike for a cool Excel trick. :)
Amazing as always Mike. You are the best.
I usually replace the + or condition with (ISNUMBER(XMATCH(E5:E14,$L$18:$L$19))) if I have to find multiple values.
=FILTER(B5:F14
,( (B5:B14>=H18)*(B5:B14
LOVE it : ) : ) The ISNUMBER/XMATCH rules for more than two OR conditions : )
another known technique:
COUNTIF($L$18:$L$19 , E5:E14)
That's absolutely AMAZING Mike ... but i miss the excel file too
Thanks Teammate. I just added.
I will be coming back to this one!
As always, an outstanding video Mike, thanks!
Token of Gratitude!
I hope all is well at home 🤞🏿
Best Wishes!
Thank you so much fort the kind token : ) : ) : ) : ) I am still down in California taking care of my Mom. Thank you for the well wishes and support, Ankursharma!!!!
1:43 i have this book.
I can say its superb Masterpiece of a book.
For writing this Mike deservers at least 5 Nobel prizes :)
Amazing and FUN!!!! Thanks Mike. :) :)
Thank you Mike for this great video. 👍 I hope your mom's health is well. My prayers 🙏
Super useful, thanks a lot Mike
Wow great
wow, thanks you
Thanks Mike
Nice!
Long time so see : )
Thank you Sir.
I have been looking for the same.
Yes it is the only app that matter :-)
: ) : ) : )
Thank you
En espera que lo suelten. Pero sin el error fantasma
MR Mike thanks ,
please try as you can to do tricks with power query
plz do it with power query also
thanks ,
it is just a auto filter in Power query. Here is a list of the 202 PQ vids I have done: ruclips.net/p/PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK
Is there a way to use conditional formatting to highlight rows that match criteria?
Yes, Search my channel. I have about 10 videos :)
As you know Mike! In realworld..;), When filter function meat date It must be come up with headache. especially date fields are blank randomly. ㅜㅜ
Hi Sir how do we use byrow/bycol function with RANK.EQ to spill the results rather than dragging
Here is how to spill aggregate calculations:
ruclips.net/video/qkTAtVqYXeE/видео.html
Thank you very much.Can we use BYROW and BYCOL together as I have 11rows and 6 Colums @@excelisfun
Hey Mike as always you are awesome I request you can you make python in excel video I am qureous about that concept
I can't for almost a year becasue I am taking care of a sick Mom. But sometime in future : )
Hi there, Cool video but I have a question, what is the difference between this kind of filter and the common kind of filter, the automatic ones.
If I put an automatic filter I can do the same, right? Or not?
Yes.
@@excelisfun thanks for. Answer me, so, why would someone do this kind of filter?