@lorenzoladejobi8701
The expo on use of "FILTER and return non-contiguous columns" is a game changer for me ! Thank you Mynda
@aviman2010
Thanks Mynda. You've turned my world upside down (in a positive way) yet again. Love your teaching style
@MichaelBrown-lw9kz
The way you used the CHOOSE function was brilliant. I would like to think I would have come up with this, but I don't know. Absolutely fantastic
@JeffreyWigington
I did not know about the Choose function before! That is a really nice way to rearrange columns on the filter! I add seen another method using a double filter where the inner filter was on the whole table, but the second filter was a set of logicals [1,0,0,1] to "turn on" certain columns. It works well for removing unwanted columns, but doesn't let you rearrange columns. The choose function makes this so much cleaner. Thanks for your example!
@indzara
Really liked the OR logic and the fact that everything >0 is treated the same. Nice design. Enabling multiple error values is another good tip. Thanks for sharing. š
@nikkicroxall6113
Genuinely spent the last two days straight trying to figure out how to rearrange the columns.... thank you!!!
@gsracharya
Wow, I was dying to filter only 3 column out of 15 columns, with table having hundreds of rows, and you have just given me the torch for my dark road. Thank you very much.
@josecarlosconejo5724
Amazing!! I knew how to get only the columns that I wanted by wrapping the FILTER function with another FILTER and a set of 1s and 0s as criteria, but I had no idea about how to rearrange the column order. Very smart use of the CHOOSE function. I use FILTER a lot at work, but with your tutorial I will take it to a new dimension. Many thanks for sharing.
@karllinguistik7244
I'm really fascinated with the way you handle the Boolean logic, it's just amazing.
@brianwied3702
The last segment on discontiguous columns saved me a lot of time, excellent video!
@jcethan2859
FILTER CHOOSE is my new favorite thing about O365, until the next thing inevitably takes its place. Great video! š
@robertoschenone9648
The truck for filtering not contiguous columns Is really great! The best I have seen so far
@Ahmed-fq6si
This is so useful and amazingly well explained as usual. Wish I could give 1000 likes to each of your videos.
@davidferrick
good stuff, never thought of using the CHOOSE option for non-contiguous column returns.
@stevereed5776
Had to watch this twice to get my head around it, mainly because I've never used the CHOOSE function. This works great so will definitely be using it. Thanks for the video
@sachinrv1
Excel in Office 365 has much more to offer than one can imagine. Wonderfully explained :)
@ravichandrankannappan6552
Very good way of illustrating how 'Filter' function works. Thanks 'MyOnlineTrainingHub' for teaching me nicely the Filter function. Please keep it up!
@brandonnesset1571
You made my day today. You are always someone I can rely on to learn something new. Thank you Mynda!:goodvibes:
@garyallan69
Love the Non - Contiguous columns. Iām now starting to use Choose for the first time in my life LOL
@PCor18
Disclaimer: If any European people have trouble getting this to work use {1\2} instead of {1;2} if the semicolon is your default separator. After I spent nearly an hour figuring out this wasn't working because differences in regional formatting I'm so grateful for this very, very elegant solution!