number variations

[aint much cop]

Hello All,

Looking for a way or template that if i put in a list of 2 digit numbers
say seven of them , that i can find the number of 2,3,4 number variations of
them.i do not want to add etc but use the numbers that i imput

 

[Pritesh Shah]

The question is not clear...pls elaborate.

 

[Norman Jones]

Hi Aint much cop,


If you want to list the results then see the follwing post by Tom Ogilvy for
code by Myrna Larsen:

http://tinyurl.com/e2pyz

If you want to return the number of combinations or permutations, look at
the worksheet functions Combin and Permut in Help.

 

[Max]

Just to add on a little to Norman's lead ..
Here's a link to download a nice, easy-to-use sample file
with Myrna's code implemented:
http://savefile.com/files/4491071