It’s been a great competition and now it is time to announce the winners.
Check out my new Excel challenges page to find out which solutions I received and who won the prize for best solution!
I hope you enjoyed this challenge. If you have more ideas for challenges, let me know!
Regards,
I was surprised not to find a VBA-approach that uses recursion.
So I created one myself:
https://www.snb-vba.eu/bestanden/__VBA_Recursion_combinations.xlsb
Since you asked for explanations for the combinations algorithm, the VBA-approaches and the use of Excelformulas I provided them here: http://www.snb-vba.eu/VBA_Combinations_en.html