number variations
 

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

The question is not clear...pls elaborate.

"aint much cop" wrote:

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

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.


---
Regards,
Norman



"aint much cop" <aint much wrote in message
...
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

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----