Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number anagram
I have theses numbers:- 1, 2, 3, 4, 5, 6, 7, 8, 9 and I need to work out all
the combinations these numbers have in sets of 4. By this I mean for example, 1234, 1236 etc....using each number once in a set..(so there are no duplicates) i.e. Not 1124. Is there any worksheet function/formula I could make in excel to work out and hence display all the possible four set combinations there are? But not the total of combinations i.e. just one number..because I already know how to calculate the number of combinations there can be. Or is there any alternatives other than writing them all out by hand?! Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
multiply by actual number in cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |