View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nutsoup
 
Posts: n/a
Default Excel Genius Required!


hi there,

this doesn't have to be aesthetically pleasing but what i'm after is
for excel to display the results of how many different combinations of
1s and 0s there are in 16 rows.

as an example i have manually done 2 rows which gives four outcomes:

[image: http://i1.tinypic.com/n5o5f8.jpg]


i'm assuming 16 rows will give 256 outcomes but can i have them all
somehow displayed in excel. it can be with anything, dots and crosses,
x or y whatever, i just need all the possible combinations displayed.

[image: http://i1.tinypic.com/n5o6ep.jpg]


any help, suggestions or advice is much appreciated!


--
nutsoup
------------------------------------------------------------------------
nutsoup's Profile: http://www.excelforum.com/member.php...o&userid=31191
View this thread: http://www.excelforum.com/showthread...hreadid=508599