Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |