|
-
Feb 11th, 2013, 06:58 PM
#1
Thread Starter
New Member
[Excel] Combinations again - what macro will find them all?
I'd like to have a column of data (integers from 1-88) that is of variable length x (could be 1 to 20 rows)
I would like to create (on a separate sheet, perhaps) a list of all the possible subsets ranging in size from 2 to (x-1), along with the sums for each set.
I know I could probably nest a bunch of loops and exit at some point, but I'm sure there is a MUCH better way to write a macro, maybe a recursive function of something. My problem is that I don't really know VB. So will anyone write that sub for me?
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|