ExcelBanter - how do i create all possible combinations from a set of nos. in ex

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how do i create all possible combinations from a set of nos. in ex (https://www.excelbanter.com/excel-programming/423660-how-do-i-create-all-possible-combinations-set-nos-ex.html)

Combination Confusion

how do i create all possible combinations from a set of nos. in ex

i have to map out all possible combinations for a lottery from a range of 1-4
in excel and i can't find the formula in the Excel help file. can anyone
shed some light on this. it is for a school project in statistics.

All times are GMT +1. The time now is 03:48 AM.