Jan 14 2023 09:10 PM
Hi, I am trying to get all the combinations one can fine from 1 to 35 by sets of 5 and in order.
I would also like to have them separated by column, example
1 2 3 4 5
1 2 3 4 6
1 2 3 4 7
Google told me there are 324,632 combinations, but I am not sure. I would like to have all of them in an excel sheet. I also would love to learn the steps to eventually do it on my own, a video would be nice. Thanks
Jan 15 2023 02:25 AM
I had an old workbook lying around that does this using VBA. You'll have to allow macros.
Others will undoubtedly post a dynamic array formula using the new functions available in Microsoft 365.
Jan 16 2023 02:41 PM
@Hans Vogelaar I tried to ignore this but in the end I couldn't let you down. Attached is a recursive LAMBDA function
Jan 16 2023 02:51 PM
Great to see that this is possible with Lambda. Thanks!