Great example on how to perform a Cartesian joint. A bit more involved than doing it in Powerquery however i wanted to see an excel option using dynamic arrays. Thanks for posting this great video
It is kind of you to share, but this, despite copying precisely your sheet content and actions, did not work for me. I wonder if the Excel versions are different. Mine is whichever version come with Windows 10 Pro Version 21H2.
I REALLY....REALLY NEED HELP WITH MY SITUATION, PLEASE! I have combinations in multiple cell blocks. I need to add a selection of numbers to all cellblocks while maintaining the correct numerical order of the combination. For example: I have cell blocks containing such combinations as: 03 05 09....15 17 21...ect and I want to add 2 even numbers say 2 and 4. How can I add to cell blocks making them 02 03 04 05 09, ect ??? BIG thanx!
I am absolutely smashed. So many ppl doing this in complicated ways, and u made it so clearly and simple. Congrats and tank u so much.
Whoever is this miraculous lady, God Bless Her!
You are an awesome teacher Karina. Thank you
Wow, your brain is a beautiful thing. Thank you Karina!
Oh mah gawd I had no idea this kind of power was possible. I was blown away seeing you could create variables, but then a Lambda function, too!?!? 🤯🤯
That's exactly what i've been looking for. Many thanks
Myself: Writing a VBA function. Other youtubers: Bother Power Query. Karina Adcock: Hold my ! and give me LAMBDA.
Great example on how to perform a Cartesian joint. A bit more involved than doing it in Powerquery however i wanted to see an excel option using dynamic arrays. Thanks for posting this great video
My god, you're a goddamn legend Karina!!!!!
This is pure genius!
Can you please make a video to make such all combinations for 3 or more columns.
I cracked up for 3 columns, have used another separator for the third column. It worked fine
Omg! life saver! exactly what i needed!
What an amazing video!!!! Hats off to you. Cant thankyou enough for this!
Wow, mind blown. Thank you.
great video and to the point, saved me hours of googling :)
Help please- Out of 54 words/statement, i need to make different combination of words not exceeding 9 in a group. What formula can i use?
This is a great time saver! Thank you!
How do I use this if my array has blanks? it not working in that case?
Brilliant!
It is kind of you to share, but this, despite copying precisely your sheet content and actions, did not work for me.
I wonder if the Excel versions are different.
Mine is whichever version come with Windows 10 Pro Version 21H2.
I REALLY....REALLY NEED HELP WITH MY SITUATION, PLEASE! I have combinations in multiple cell blocks. I need to add a selection of numbers to all cellblocks while maintaining the correct numerical order of the combination. For example: I have cell blocks containing such combinations as: 03 05 09....15 17 21...ect and I want to add 2 even numbers say 2 and 4. How can I add to cell blocks making them 02 03 04 05 09, ect ??? BIG thanx!
Wow, this is great. Thank you Karina, You have saved me lots of time for my report. can I be able to have three sets of data instead of two?
I am not able to copy the value produced. How can I copy?
Is it possible to learn this power... for Google Sheets?!
Awesome tutorial, YOu may need a lozenges btw.
Incredible !
i do =A1:A4 & D2# is not work
Brilliant, thank you
Bravissima! Grazie.
Does this work on google sheets, and can I use this to combine 3+ lists?
wow, genius
What.....?