I need to work out both the number of, AND the actual combinations for the following scenario...4 questions with the same 3 answers (Y, N or P) to each question. Possible combinations are...
Q1 Q2 Q3 Q4
Y N Y Y
Y P Y Y
P P Y Y etc, etc
But how many? and how to generat them in excel?
Last edited by cjt_choccy; 11-20-2011 at 11:34 AM.
81
i used this
http://www.ne.jp/asahi/math.edu/ami/myprog/jk_eng.htm
and input yyyyppppnnnn and chose 4 permutations from the options
yyyy
yyyn
yyyp
yyny
yynn
yynp
yypy
yypn
yypp
ynyy
ynyn
ynyp
ynny
ynnn
ynnp
ynpy
ynpn
ynpp
ypyy
ypyn
ypyp
ypny
ypnn
ypnp
yppy
yppn
yppp
nyyy
nyyn
nyyp
nyny
nynn
nynp
nypy
nypn
nypp
nnyy
nnyn
nnyp
nnny
nnnn
nnnp
nnpy
nnpn
nnpp
npyy
npyn
npyp
npny
npnn
npnp
nppy
nppn
nppp
pyyy
pyyn
pyyp
pyny
pynn
pynp
pypy
pypn
pypp
pnyy
pnyn
pnyp
pnny
pnnn
pnnp
pnpy
pnpn
pnpp
ppyy
ppyn
ppyp
ppny
ppnn
ppnp
pppy
pppn
pppp
Last edited by martindwilson; 11-20-2011 at 08:37 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
3 to the power of 4 = 81 combinations
Regards
Special-K
I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.
A combination of CHOOSE, MOD, INT and ROW functions like in attached workbook.
Beau Nydal
Thanks for response. Problem now resolved and can use solution for similar porblems in the future.
Very helpfull and much appreciated
There's a workbook that will do this at http://www.box.com/shared/ubd28tissi
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks