Filter Non Adjacent Columns in Excel- Change Returned Order Dynamically- Awesome Tricks

[@123mailashish]

U r nothing but bliss Mr. Nabil Murad!!!

[@Officeinstructor]

Thank you so much

[@allanallansson9532]

Best so far!!! Other videos on this topic gets stuck with hardcoded curly brace array constants and are NOT dynamic regarding columns to be returned; order of those columns is not even addressed. You aced this one!

[@sasavienne]

1) An excellent tutorial. 2) Simply great. 3) Deserves all my gratitude. 4) Very professional. 5) An awesome combination of useful formulas. 6) Many thanks. Merci beaucoup. Muchas gracias. Grazie mille. Tusen tack. شكرا لك .Vielen Dank.. تحياتي .. سليم من هامبورج الألمانية..

[@Officeinstructor]

Thank you for the nice motivating words... Truly appreciated

[@IvanCortinas_ES]

Great Nabil, GREAT!! When someone asks what the MATCHX function is for, here's an authentic answer. Thank you!!

[@stevennye5075]

Excellent Explanation!!!!!

[@Officeinstructor]

Glad you liked it

[@msmith3090]

Excellent, top notch! I will be using this technique. Thank you very much!!

[@nadermounir8228]

A very insightful tutorial. Very nice tricks.

[@Officeinstructor]

Thank you... Glad you found it valuable

[@badawi800]

I am always amazed by how you simplify complex concepts in your tutorials. Thank you Nabil.

[@Officeinstructor]

So nice of you...Glad you liked the video

[@billywiswall6233]

Awesome video Nabil! Thank you for basing your result off of multiple conditions and treating us to an old school bonus formula as well!

[@Officeinstructor]

Glad you enjoyed it!

[@iankr]

Wonderful! Thank you, Mr Mourad.

[@mushtaqali267]

U r genius over the globe

[@redhaakhund1271]

ماشاء الله - عمل جدا رائع👍👍👍👍👍

[@Officeinstructor]

Shokran

[@sankaraniyer2167]

Hi You are genius and concepts are cleared by you awesome and amazing. I have been watching all your tutorials. Great work

[@Officeinstructor]

Thanks a ton

[@charliearmour1628]

Wow, awesome. So impressed. Thank you so much. Off to buy your Datavalidation book!

[@rogerlococo4709]

Beautiful tutorial , complex data analysis made simple in office 365 awesome video thank you

[@Officeinstructor]

Glad you liked it

[@ellukayou]

I did strugge with columns once. Thank you

[@Officeinstructor]

You are welcome

[@fairozemm5505]

Thank you very much, it is very clear and easy to understand.

[@Officeinstructor]

You are most welcome!

[@nerenlakhraj5252]

Thank you Nabil ... this was truly an awesome and valuable trick

[@Officeinstructor]

Thank you for watching and glad you found it valuable

[@Luciano_mp]

No words, very helpful, brilliant. Thank you so much Nabil!👍...👏

[@Officeinstructor]

Glad you liked it! Thanks for watching

[@shoppersdream]

Very nice! I was trying it on a Laptop and not on Mac so it went fine until 18:18 but I think there is a step that is missing. We did not create a list for the 5 columns so I don't see any list over there. Did I miss something? So I can't choose the Phone for the Fist Name or Last Name and so on...

[@jueroe3753]

Sorry for having only two thumbs, that s amazing, thank you 🙏

[@vijayarjunwadkar]

Wow, wow! You are awesome Nabil! While having tools is one thing, how to use them effectively and innovatively is another, which I know is your USP! Keep it up! Waiting for more! 😊👍👌

[@Officeinstructor]

Thank you so much 😀

[@sergiomandujano]

This was very Helpful thanks so much, I follow you since a while and you make my life easier... QUESTION, what function would you suggest for this dynamic table to show only the top 3 based on balance?

[@Saad.PS2009]

بالتوفيق ان شاء الله تعالى عمل قمة في الروعة والجمال

[@Officeinstructor]

شكرا صديقي العزيز

[@shoppersdream]

It's very nice. The step which was missing was on the M3 tab, I had thought that you already had the list but it was not there so I had to create the list. You know for Kansas there is no Married so it gives an error. Can we show some message like "There is no married" or some friendly result. Thanks

[@syedaneesdurez8766]

Amazing. Sir is there way to select a range of multiple states and other criteria in range and then get output rather than single state... Please share your knowledge. Appreciate

[@mutlaqsaud1028]

بارك الله فيك عمل امثر من رائع

[@Officeinstructor]

شكرا جزيلا و انا سعيد إن الفيديو عجبك

[@mtotowamungu8259]

Many thanks

[@Officeinstructor]

You are welcome

[@ellukayou]

Can it be done in such a way that the columns are dynamic? You can put a validation in the headersm I tried with combinations of TEXTJOIN, INDIRECT and TRANSPOSE but I did not succeed.

[@Officeinstructor]

i did it in the same video... towards the end (can't remember, that was long time ago)

[@jshah56]

Will please show how can we get filtered data with using sort function

[@davorercegovac3674]

Thank you👍 EXCELlent😃👍

[@Officeinstructor]

Thank you too!

[@nadermounir8228]

Is you new book available electronically for purchase? Instead of a hard copy?

[@Officeinstructor]

Yes: officeinstructor.com/shop/

[@tobayekaina8610]

Dear Sir Thanks. Awesome

[@Officeinstructor]

So nice of you...Thank you

[@TheSTEPHEN009]

Sir is it possible for you to show in formula for those who are using office 2016 or later like me. Please requesting..

[@Officeinstructor]

Replace the Filter/Sequence/Row function with an aggregate function (watch my tutorial on aggregate) and replace the Xmatch with a Match

[@TheSTEPHEN009]

@@Officeinstructor Ok Sir Thank you very much..your videos are mind blowing impressive and phenomenal..something which is different from others..I just love to watch and implement in my work..

[@shoppersdream]

Thanks! This sequence function does not work on Mac.

[@Officeinstructor]

I am sorry, I am not familiar with Mac

[@PONCEJE]

You are awesome

[@JoseAntonioMorato]

Two more ways to solve the problem: =INDEX(Data;FILTER(SEQUENCE(ROWS(Data));(Data[State]=K2)*(Data[Married]=L2));XMATCH(K4:O4;Data[#Headers])) =CHOOSECOLS(FILTER(DataB,(DataB[State]=K2)*(DataB[Married]=L2)),XMATCH(K4:O4,DataB[#Headers])) 🤗

[@mutlaqsaud1028]

السؤال ياستاذ نبيل لماذا لاتشرح بالعربي

[@Officeinstructor]

أنت أثرت موضوع فعلا بيشغلني لكن العقبة إن فيه بعض مصطلحات في الإكسيل معرفهاش بالعربي فهل لو أنا أشرح بالعربي لكن أقول مصطلحات إنجليزي ده يبقي شئ منتقد؟؟ مش عارف

[@mutlaqsaud1028]

@@Officeinstructor اقسم بالله ان شرحك اكثر من رائع وانا صار لي فترة اتابعك على اليوتيوب لكن لو تشرح بالعربي ياسلام

[@eljinet]

So on Google Sheets I have this: =iferror(FILTER('RAW DATA 2'!$B$2:$G,'RAW DATA 2'!$B$2:$B>=$B$1,'RAW DATA 2'!$B$2:$B