Re: Number anagram

Logically, look at it this way :
When you select the first number you have 9 possibilities
When you select the second number you have 8 possibilities left
and so on
Therefore...

=9*8*7*6 or 3024

Here is a link with the formula you need. The excel function is
FACTORIAL().

http://www.andrews.edu/~calkins/math/webtexts/prod02.htm#PERM

-- Carlos

"pav55" <pav55@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B9585EC9-7C43-409F-82E6-E7D2EEB849BD@xxxxxxxxxxxxxxxx
> 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 work*** 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.


.