LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula required for excel 2002 jmlsav2 Excel Discussion (Misc queries) 2 September 21st 05 10:12 AM
Value Errors with EXCEL XP not showing up in EXCEL 2000 goodguy Links and Linking in Excel 0 July 19th 05 02:38 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
SPECIFY REQUIRED PAPER SIZE IN EXCEL 2000 Augustine Excel Discussion (Misc queries) 0 January 17th 05 12:05 PM


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"