Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combinations & Perms
I know this question has been asked and answered many times over. I just
need a little help understanding the finer points. OK, Here goes. I am attempting to find a way to calculate all of the possibilities of a group/numbers givin certain restrictions. I have found Myrna Larson's formula originally posted in July of 2000. One of the pages is code is listed on is here...http://www.ozgrid.com/forum/showthread.php?t=28321 Where I really need help is in the set up. Where do I put this code to get it to run? I am using Office 2007/Excel. Please help. Thanks, GK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combinations & Perms
See here for help on macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm "GK" wrote: I know this question has been asked and answered many times over. I just need a little help understanding the finer points. OK, Here goes. I am attempting to find a way to calculate all of the possibilities of a group/numbers givin certain restrictions. I have found Myrna Larson's formula originally posted in July of 2000. One of the pages is code is listed on is here...http://www.ozgrid.com/forum/showthread.php?t=28321 Where I really need help is in the set up. Where do I put this code to get it to run? I am using Office 2007/Excel. Please help. Thanks, GK |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combinations & Perms
I tried what I believe I was supposed to do but I get an error. It says
overflow. "Toppers" wrote: See here for help on macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm "GK" wrote: I know this question has been asked and answered many times over. I just need a little help understanding the finer points. OK, Here goes. I am attempting to find a way to calculate all of the possibilities of a group/numbers givin certain restrictions. I have found Myrna Larson's formula originally posted in July of 2000. One of the pages is code is listed on is here...http://www.ozgrid.com/forum/showthread.php?t=28321 Where I really need help is in the set up. Where do I put this code to get it to run? I am using Office 2007/Excel. Please help. Thanks, GK |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combinations & Perms
Overflow usually occurs when you have a number which is greater than is
possible in a variable type e.g. very large number in an integer (rather than LONG) variable. I have used this code frequently and haven't had any problems. What is your input data? "GK" wrote: I tried what I believe I was supposed to do but I get an error. It says overflow. "Toppers" wrote: See here for help on macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm "GK" wrote: I know this question has been asked and answered many times over. I just need a little help understanding the finer points. OK, Here goes. I am attempting to find a way to calculate all of the possibilities of a group/numbers givin certain restrictions. I have found Myrna Larson's formula originally posted in July of 2000. One of the pages is code is listed on is here...http://www.ozgrid.com/forum/showthread.php?t=28321 Where I really need help is in the set up. Where do I put this code to get it to run? I am using Office 2007/Excel. Please help. Thanks, GK |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combinations & Perms
C
3 1 2 3 4 5 That is exactly my input data. I was attempting to do a test to see if I was putting in the code correctly. PLease help!!!! Thanks, GK "Toppers" wrote: Overflow usually occurs when you have a number which is greater than is possible in a variable type e.g. very large number in an integer (rather than LONG) variable. I have used this code frequently and haven't had any problems. What is your input data? "GK" wrote: I tried what I believe I was supposed to do but I get an error. It says overflow. "Toppers" wrote: See here for help on macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm "GK" wrote: I know this question has been asked and answered many times over. I just need a little help understanding the finer points. OK, Here goes. I am attempting to find a way to calculate all of the possibilities of a group/numbers givin certain restrictions. I have found Myrna Larson's formula originally posted in July of 2000. One of the pages is code is listed on is here...http://www.ozgrid.com/forum/showthread.php?t=28321 Where I really need help is in the set up. Where do I put this code to get it to run? I am using Office 2007/Excel. Please help. Thanks, GK |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combinations & Perms
No problem here with your data.
I assume you haven't changed the code AND it was copied correctly? "GK" wrote: C 3 1 2 3 4 5 That is exactly my input data. I was attempting to do a test to see if I was putting in the code correctly. PLease help!!!! Thanks, GK "Toppers" wrote: Overflow usually occurs when you have a number which is greater than is possible in a variable type e.g. very large number in an integer (rather than LONG) variable. I have used this code frequently and haven't had any problems. What is your input data? "GK" wrote: I tried what I believe I was supposed to do but I get an error. It says overflow. "Toppers" wrote: See here for help on macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm "GK" wrote: I know this question has been asked and answered many times over. I just need a little help understanding the finer points. OK, Here goes. I am attempting to find a way to calculate all of the possibilities of a group/numbers givin certain restrictions. I have found Myrna Larson's formula originally posted in July of 2000. One of the pages is code is listed on is here...http://www.ozgrid.com/forum/showthread.php?t=28321 Where I really need help is in the set up. Where do I put this code to get it to run? I am using Office 2007/Excel. Please help. Thanks, GK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of combinations | Excel Discussion (Misc queries) | |||
Combinations | Excel Discussion (Misc queries) | |||
Possible Combinations | Excel Discussion (Misc queries) | |||
getting combinations | New Users to Excel | |||
Combinations | Excel Worksheet Functions |