Hello,
I need a formula which produces a list of all possible combinations of 4 numbers using a group of 5 numbers without repetition . For example:
If the group were 1 2 3 4 5
I would need to produce a list like this:
1-2-3-4
1-2-4-5
Etc
My knowledge of excel is relatively basic, so any help would be appreciated!
Thanks
I need a formula which produces a list of all possible combinations of 4 numbers using a group of 5 numbers without repetition . For example:
If the group were 1 2 3 4 5
I would need to produce a list like this:
1-2-3-4
1-2-4-5
Etc
My knowledge of excel is relatively basic, so any help would be appreciated!
Thanks