Forum Discussion
All combinations of 5 numbers from 1 to 35
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 ...
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.
HansVogelaar I tried to ignore this but in the end I couldn't let you down. Attached is a recursive LAMBDA function
Great to see that this is possible with Lambda. Thanks!