Permutation and Combination

[DEWAL]

HI guys,

I want to display all the combinations of the numbers from 1 to 10. Any pointers?

[Pepe Le Mokko]

Try Google Lots of answers

[Fotis1991]

http://excel.tips.net/T006766_Listing_Combinations.html

[AndyLitch]

=PERMUT(A1,B1)+A1

Where A1 = 10, B1 = 2

Providing it's combinations of 2 numbers you are looking for.

[MrShorty]

I have found the Wikipedia page to be useful http://en.wikipedia.org/wiki/Permutation Section 5.2 has a brief discussion, sometimes with links to other articles, of some algorithms for generating permutations.