combination calculation

C

chief

is there a code that can be used to calculate how many combination
there can be for a given set of a number? For instance, i have 1
items on a card, and there can only 2 choices (A or B) for each item o
that card. I need to know how many cards it would take to cover al
possible combinations. Furthermore, is there a way those A's and B'
could be translated or input onto my excel sheet into consequent cell
so that I could see what each combination looks like?

ie. cells A1 to A14 would be:

1-A
2-B
3-B
4-B
5-B
6-B
7-B
8-B
9-B
10-B
11-B
12-B
13-B
14-B

15-A
16-A
17-B
18-B
19-B
20-B
21-B
22-B
23-B
24-B
25-B
26-B
27-B
28-B

any thoughts, thank
 
M

Mike A

You have 2^14 = 16384 combinations.

Mike Argy
Custom Office solutions and
Windows/UNIX applications
 
T

Tom Ogilvy

If you have the Analysis toolpak install (if not, install it), put this in a
cell in row 1

=RIGHT("00000000"&DEC2BIN(TRUNC((ROW()-1)/256)),6)&RIGHT("00000000"&DEC2BIN(
MOD(ROW()-1,2^8)),8)

then drag fill down to row 16384

If you want it to show A and B, then select the column and do Edit=>Copy,
then Edit=>PasteSpecial and select Values

Now select the column and do Edit=>Replace, replace 0 with A then repeat
replacing 1 with B.
 
Top