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!
@ExcelHechoFacil10 ай бұрын
Mike cada video tuyo es una enseñanza completa, un contenido invaluable. Gracias por seguir. Un abrazo fuerte.
@roywilson958010 ай бұрын
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!
@barttitulaerexcelbart940010 ай бұрын
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 ....😉
@மின்விரிதாள்_விரிப்போம்_வாங்க10 ай бұрын
Straight to the point. No nonsense! That's Mike! Thank you!
@gilbertosegoviano770110 ай бұрын
You are the best Mike Thanks for sharing 😊
@andrewjohnson435210 ай бұрын
I will be coming back to this one!
@kiwikiow10 ай бұрын
Thank you Mike for a cool Excel trick. :)
@kebincui10 ай бұрын
Great as always.Thanks Mike
@baruchschwartz8193 ай бұрын
What a teacher!
@excelisfun3 ай бұрын
Glad to help!!
@johnborg541910 ай бұрын
Amazing and FUN!!!! Thanks Mike. :) :)
@HusseinKorish10 ай бұрын
That's absolutely AMAZING Mike ... but i miss the excel file too
@excelisfun10 ай бұрын
Thanks Teammate. I just added.
@AnshupalBantra10 ай бұрын
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
@excelisfun10 ай бұрын
LOVE it : ) : ) The ISNUMBER/XMATCH rules for more than two OR conditions : )
@viktorasgolubevas238610 ай бұрын
another known technique: COUNTIF($L$18:$L$19 , E5:E14)
@chrism903710 ай бұрын
As always, an outstanding video Mike, thanks!
@lucaviglio120610 ай бұрын
Super useful, thanks a lot Mike
@nadermounir822810 ай бұрын
Thank you Mike for this great video. 👍 I hope your mom's health is well. My prayers 🙏
@ExcelInstructor10 ай бұрын
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 :)
@ankursharma615710 ай бұрын
Token of Gratitude! I hope all is well at home 🤞🏿 Best Wishes!
@excelisfun10 ай бұрын
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!!!!
@rajuj254810 ай бұрын
Wow great
@erdal468710 ай бұрын
Thanks Mike
@reighbernal18810 ай бұрын
I have been looking for the same.
@fokhrulislam263310 ай бұрын
Thank you Sir.
@fernando516610 ай бұрын
wow, thanks you
@NoShadowOfDoubt18 ай бұрын
Nice!
@excelisfun8 ай бұрын
Long time so see : )
@user-jk5gg8mv6n10 ай бұрын
Thank you
@rnunez04710 ай бұрын
En espera que lo suelten. Pero sin el error fantasma
@mohamedchakroun49739 ай бұрын
Yes it is the only app that matter :-)
@excelisfun9 ай бұрын
: ) : ) : )
@abdelazizallam10 ай бұрын
MR Mike thanks , please try as you can to do tricks with power query plz do it with power query also thanks ,
@excelisfun10 ай бұрын
it is just a auto filter in Power query. Here is a list of the 202 PQ vids I have done: kzbin.info/aero/PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK
@klfaАй бұрын
As you know Mike! In realworld..;), When filter function meat date It must be come up with headache. especially date fields are blank randomly. ㅜㅜ
@dschmid884510 ай бұрын
Is there a way to use conditional formatting to highlight rows that match criteria?
@excelisfun10 ай бұрын
Yes, Search my channel. I have about 10 videos :)
@rtrbs838310 ай бұрын
Hi Sir how do we use byrow/bycol function with RANK.EQ to spill the results rather than dragging
@excelisfun10 ай бұрын
Here is how to spill aggregate calculations: kzbin.info/www/bejne/p5y3cqeMpr6Lm6c
@rtrbs838310 ай бұрын
Thank you very much.Can we use BYROW and BYCOL together as I have 11rows and 6 Colums @@excelisfun
@TheAlwaysGoel10 ай бұрын
Hey Mike as always you are awesome I request you can you make python in excel video I am qureous about that concept
@excelisfun10 ай бұрын
I can't for almost a year becasue I am taking care of a sick Mom. But sometime in future : )
@viviendoen36010 ай бұрын
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?
@excelisfun10 ай бұрын
Yes.
@viviendoen36010 ай бұрын
@@excelisfun thanks for. Answer me, so, why would someone do this kind of filter?