9 Exciting NEW Excel Functions for Shaping Arrays - Incredible!

Показать описание

In this video I cover 9 new array shaping Excel functions including TOCOL, TOROW, WRAPCOLS, WRAPROWS, TAKE, DROP, CHOOSECOLS, CHOOSEROWS and EXPAND. I also use them in some advanced techniques, which is where their real power is realised. See the timestamps below to skip to the function you want to learn.

0:00 New Excel Array Functions
0:23 TOCOL & TOROW functions
2:14 WRAPCOLS & WRAPROWS functions
3:44 TAKE & DROP functions
5:49 CHOOSECOLS & CHOOSEROWS functions
8:08 EXPAND function
9:01 Advanced Examples

Рекомендации по теме

Комментарии

I just want. to say thank you so much for the content and explanation.

israrahmad

Your presentations are clear & well organized 👏 I'm fortunate to bump into the right channel.

ignatiussilveira

In your last advanced example, I changed the formula to be even more advanced:
=VSTACK({"Post Code", "Suburbs"}, SORT(FILTER(HSTACK(TOCOL(CHOOSEROWS(C31:G31, 1, 1, 1, 1)), TOCOL(C32:G35)), TOCOL(C32:G35)<>""))) 🤗

Dear Mynda,
I was impolite not to mention that I loved the video and that it inspired me a lot, as I hadn't thought about nesting the formulas as they were nested in your advanced examples.
Thanks for the great ideas. 🤗

JoseAntonioMorato

I used to think I was an excel Ninja. Thanks for bringing me back to reality. 😂

kevinmundis

What you are doing is a great assistance to all .. please accept my true respects and best of luck wishes ... you are great person!

jihadalbustanji

You know what, i have been addicted to your videos. You are doing great job and i keep growing myself thanks to your instructional videos. Warm regards

TangogarajTangoKursu

I hope these get pushed to all users soon, much easier than the workarounds!

gtb

Great video!!
For last example, an alternative, dynamic solution if will get more data to the right:
=HSTACK(TOCOL(IF(C32:G35<>"", C31:G31, NA()), 2), TOCOL(IF(C32:G35<>"", C32:G35, NA()), 2))
-or with single variable the entire array/table "t":
=LET(t, C31:G35, a, DROP(t, 1), HSTACK(TOCOL(IF(a<>"", TAKE(t, 1), NA()), 2), TOCOL(IF(a<>"", a, NA()), 2)))

Excelambda

Very interesting. Newer heard before about these functions

alexanderbaranov

It was a clear explanation. Thanks Mynda!

LuisCarlosChavez

Hi Mynda!These New Functions Certainly Look Really Interesting...Thank You :)

darrylmorgan

Excellent! and very well explained. Thanks as always for the helpful downloads!

colinhuntley

Thanks Mynda! I have to spend some time using these functions, they look really powerful

chrism

man i couldn't wrap my brain around the versatility of all these new functions

MuhtashimKukda

Now I have learned some cool new Ninja techniques to be applied to my work. 😎 I'm going to feel like a ninja when I'll be applying this formulas. 😎😂 Just love your videos. Love from India.

mugalismailb.