You sir are a life saver!!!! I was trying to find a way to do this for hours coz i had 12 lists. Hours! You were my hail Mary and you came through. Thank you so much.
Very helpful man! Saved me from a lot of trouble! 1.000 thanks! Had to do 6 table combinations and did it within 10 minutes after watching your video! Cool stuff!
Hi Doug. Nice approach! Thanks for sharing this method of making all possible combinations from two or more lists of data.. and breaking it out to .txt. Thumbs up!!
Thank you, Doug!. This was really helpful. I had to create combinations from two columns, and I got it done in less than 5 mins after watching your video. Thank you so much.
Hi, it's great, Can you please help to also include vertical think to make combination Like A 1 A 2 A 3 A A A B A C And all.. Mean also include vertical combination
Thanks Doug. Is there a way or a filter to remove repeats in the combos? Can I combine numbers in sequence order without higher numbers before before lower numbers. I want to use to generate lottery picks. Thanks
Great video. Is there a way to filter the combinations with repetitions in power query as well? For example: avoid 1-1-1-1 of 1-1-1-2 or 1-1-2-3, etc.... where we can generate combinations but avoid the same number repeating within a combination?
Is there a shortcut formula in way in which I could filter and apply the query ? For example filter list 1 for one value and then apply the query on other 3 lists and so on for all the other values in list one !
yes does do that first step with the filter. maybe this video(s) will help czcams.com/video/4FsFJPuN6Ro/video.html czcams.com/video/YWHyArE90QM/video.html
You sir are a life saver!!!! I was trying to find a way to do this for hours coz i had 12 lists. Hours! You were my hail Mary and you came through. Thank you so much.
Glad it helped!
Power Query certainly make this easier than older methods like with VBA : )
Yep, PQ is the best!
Very helpful man! Saved me from a lot of trouble! 1.000 thanks! Had to do 6 table combinations and did it within 10 minutes after watching your video! Cool stuff!
Thanks for the comment!
Hi Doug. Nice approach! Thanks for sharing this method of making all possible combinations from two or more lists of data.. and breaking it out to .txt. Thumbs up!!
Very welcome!
Thank you, Doug!. This was really helpful. I had to create combinations from two columns, and I got it done in less than 5 mins after watching your video. Thank you so much.
Thanks, glad it worked!
THANK YOU SO MUCH
You’re welcome!
thank you so much, this helped a lot 👑
Glad it helped!
Had to go through the same exercise myself Douglas...glad I know I did it right, the same as you 😉
Excellent!
Thanks for solving my problem searching for 3 hours finally problem solved.
Thanks Raza G, glad it helped!
Cool trick. Thanks Doug.
Any time!
Very very helpful. Thanks man
Glad it helped
Thank you Doug! That's great. Very helpful. You explain very clearly. Good job :)
Glad it was helpful!
Great sharing Doug, keep posting such great videos👍👍
Thanks for the comment!
Really helpful video 👌👌👌
Glad it was helpful!
great thank you.
You are welcome!
i want to add conditions before the combination
Hi, your teaching way is very great.
I want to know how I create a large volume. where My excel file hangout, Please suggest.
Hi babula tabula, thanks for the comment! Depending on the amount it may be better to export to text file
Also make a video on how to put conditions in this list of combinations.
Hi Hitendra Patil, thanks for the comment! maybe one of these may fit czcams.com/video/Z_b3iSEbvtA/video.html
Hi, it's great,
Can you please help to also include vertical think to make combination
Like
A 1
A 2
A 3
A A
A B
A C
And all..
Mean also include vertical combination
Hi Sanjay Thakur, thanks for the comment! Maybe one in these can give an idea czcams.com/video/3xR32Dva9WE/video.html
Thanks Doug. Is there a way or a filter to remove repeats in the combos? Can I combine numbers in sequence order without higher numbers before before lower numbers. I want to use to generate lottery picks. Thanks
Lottery number generator? Maybe something like this czcams.com/video/N_BrUTce1EI/video.html
Great video. Is there a way to filter the combinations with repetitions in power query as well? For example: avoid 1-1-1-1 of 1-1-1-2 or 1-1-2-3, etc.... where we can generate combinations but avoid the same number repeating within a combination?
How do I create only top 100 combination ?
Is there a shortcut formula in way in which I could filter and apply the query ? For example filter list 1 for one value and then apply the query on other 3 lists and so on for all the other values in list one !
yes does do that first step with the filter. maybe this video(s) will help
czcams.com/video/4FsFJPuN6Ro/video.html
czcams.com/video/YWHyArE90QM/video.html
Where are these combinations - AB, AC, BC & 12,13, 23? 🤔 Please reply.
Sorry, don’t understand the comment/ question... maybe other vids?
czcams.com/video/3xR32Dva9WE/video.html
czcams.com/video/4AdJeFfHuxY/video.html