Posted to microsoft.public.excel.misc

Del

Posts: n/a

Combinations

Have a look at either the =PERMUT() or =COMBIN() functions.

"Chris_t_2k5" wrote:

Hi, I am using the numbers 1 to 15. I need to calculate all the combinations
within these numbers to create 5 sets of 3 numbers

eg. 1 2 3, 4 5 6, 7 8 9, 10 11 12, 13 14 15
eg. 1 2 4, 3 5 6, 7 8 9, 10 11 12, 13 14 15

so all of the 15 numbers have to be used up each time

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Possible Combinations	Please HELP!!!	Excel Discussion (Misc queries)	1	January 6th 06 03:58 PM
Excel combinations from groups	[email protected]	Excel Discussion (Misc queries)	0	January 6th 06 01:53 PM
Tennis set combinations	Raigmore	Excel Discussion (Misc queries)	15	January 4th 06 02:10 PM
find all combinations of cells that add up to certain number	AD	Excel Worksheet Functions	1	November 17th 05 07:50 PM
triadic combinations of words	jayock02	Excel Worksheet Functions	1	June 19th 05 02:10 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us