VBA挑选组合哪一条最多

grf1973

是这个道理。确实比较烦。

香川群子

grf1973 发表于 2016-10-14 11:33
是这个道理。确实比较烦。

用我的遍历组合代码，计算了4个小时。

如果算法不好，8个小时都算不完的。

laoau138

香川群子 发表于 2016-10-13 16:49
全部组合大约需要计算3-4个小时。

实在看不懂   闪了

香川群子

覆盖5组以上的共有74组：

组合序号	11个数组合	覆盖验证
14763259	1,2,4,7,10,14,24,25,29,32,33	5=,13,47,54,85,95
31197012	1,2,7,13,14,16,29,32,33,34,35	5=,44,47,50,85,97
31406320	1,2,7,14,16,29,30,32,33,34,35	5=,44,47,85,90,97
37815800	1,2,13,14,16,29,30,32,33,34,35	5=,44,50,85,90,97
40494707	1,3,4,5,15,16,20,23,28,31,33	5=,6,25,39,51,92
64872312	1,3,11,13,14,27,29,32,33,34,35	5=,9,44,50,63,85
84285921	1,4,10,13,14,19,20,29,32,33,34	5=,1,50,85,87,95
84288936	1,4,10,13,14,19,29,32,33,34,35	5=,44,50,85,87,95
84296949	1,4,10,13,14,29,31,32,33,34,35	5=,44,50,85,95,96
84512579	1,4,10,14,19,20,24,29,31,32,33	5=,1,49,85,95,98
84512580	1,4,10,14,19,20,24,29,31,32,34	5=,1,49,87,95,98
84513059	1,4,10,14,19,20,29,32,33,34,35	5=,1,44,85,87,95
84518069	1,4,10,14,19,29,31,32,33,34,35	5=,44,85,87,95,96
127472937	1,10,14,16,19,20,24,29,31,32,33	5=,1,49,85,88,98
169720904	2,4,7,8,10,19,25,26,28,29,35	5=,13,15,26,81,94
171095057	2,4,7,10,12,19,25,28,29,30,34	5=,13,14,16,87,94
171095068	2,4,7,10,12,19,25,28,29,34,35	5=,13,14,26,87,94
171336709	2,4,7,10,19,25,26,28,29,34,35	5=,13,15,26,87,94
177218127	2,4,10,16,24,29,31,32,33,34,35	5=,44,54,88,96,97
197905511	2,6,8,11,12,13,17,18,19,22,28	5=,3,31,48,53,67
200600748	2,6,10,11,12,16,18,20,25,30,31	5=,10,16,53,57,100
201795277	2,6,11,12,16,18,20,25,26,30,31	5=,10,28,53,57,100
220326424	2,10,16,22,24,29,31,32,33,34,35	5=,34,44,88,96,97
234709950	3,4,7,8,19,24,25,26,28,29,35	5=,15,26,81,84,99
235858289	3,4,7,10,22,24,25,28,29,31,35	5=,13,26,34,75,84
272906874	3,7,10,15,22,24,25,28,29,31,35	5=,26,34,62,75,84
274908483	3,7,15,22,24,25,28,29,31,34,35	5=,26,34,35,62,84
286780197	3,12,15,16,17,22,27,29,31,34,35	6=,17,20,35,45,46,74
286811559	3,12,15,16,22,24,27,29,31,34,35	5=,17,20,34,35,45
286811811	3,12,15,16,22,25,27,29,31,34,35	5=,17,20,35,45,62
313649745	4,7,8,10,19,24,25,26,28,29,35	5=,13,15,26,81,99
313650244	4,7,8,10,19,25,26,28,29,34,35	5=,13,15,26,81,87
315144416	4,7,9,10,15,22,24,25,29,31,35	5=,13,34,62,75,76
315221859	4,7,9,10,22,24,25,28,29,31,35	5=,13,26,34,75,76
317248103	4,7,10,15,19,22,25,29,31,34,35	5=,13,35,62,75,87
317259039	4,7,10,15,22,24,25,28,29,31,35	5=,13,26,34,62,75
317259081	4,7,10,15,22,24,25,29,31,34,35	5=,13,34,35,62,75
317259564	4,7,10,15,22,25,28,29,31,34,35	5=,13,26,35,62,75
317259597	4,7,10,15,22,25,29,31,33,34,35	5=,13,35,62,75,96
329266619	4,10,19,20,24,29,31,32,33,34,35	5=,1,44,87,96,98
344771971	5,7,8,19,21,25,26,28,29,33,35	5=,15,26,73,81,91
385250955	7,8,10,19,20,22,24,29,31,32,35	5=,1,2,34,75,98
385270842	7,8,10,22,24,29,31,32,33,34,35	5=,2,34,44,75,96
391487639	7,10,12,15,16,22,27,31,33,34,35	5=,17,20,35,75,96
392237183	7,10,15,16,22,24,27,31,33,34,35	5=,20,35,75,88,96
392237233	7,10,15,16,22,24,29,31,33,34,35	5=,34,35,75,88,96
392313133	7,10,15,22,24,25,28,29,31,34,35	5=,26,34,35,62,75
392313166	7,10,15,22,24,25,29,31,33,34,35	5=,34,35,62,75,96
392313382	7,10,15,22,24,29,31,32,33,34,35	5=,34,35,44,75,96
392313579	7,10,15,22,25,28,29,31,33,34,35	5=,26,35,62,75,96
392313592	7,10,15,22,25,29,31,32,33,34,35	5=,35,44,62,75,96
392388964	7,10,16,22,24,29,31,32,33,34,35	5=,34,44,75,88,96
400749667	8,10,15,22,24,29,31,32,33,34,35	5=,2,34,35,44,96
400825249	8,10,16,22,24,29,31,32,33,34,35	5=,2,34,44,88,96
400849120	8,10,17,19,20,22,24,29,31,32,35	5=,1,2,22,34,98
400869007	8,10,17,22,24,29,31,32,33,34,35	5=,2,22,34,44,96
400917704	8,10,22,23,24,29,31,32,33,34,35	5=,2,34,44,56,96
402541320	8,12,13,21,22,24,29,30,31,32,35	5=,2,33,34,83,93
404002090	8,15,22,24,25,26,27,29,31,34,35	5=,34,35,58,62,81
404002157	8,15,22,24,25,26,29,31,32,34,35	5=,2,34,35,62,81
404002248	8,15,22,24,25,29,31,32,33,34,35	5=,2,34,35,44,62
411378657	10,12,15,16,22,24,27,31,33,34,35	5=,17,20,35,88,96
412489532	10,15,16,22,24,25,29,31,33,34,35	5=,34,35,62,88,96
412489608	10,15,16,22,24,26,27,31,33,34,35	5=,20,35,58,88,96
412489714	10,15,16,22,24,27,29,31,33,34,35	5=,20,34,35,88,96
412489748	10,15,16,22,24,29,31,32,33,34,35	5=,34,35,44,88,96
412582743	10,15,22,24,25,29,31,32,33,34,35	5=,34,35,44,62,96
412657916	10,16,19,20,24,29,31,32,33,34,35	5=,1,44,88,96,98
412753869	10,19,20,22,24,29,31,32,33,34,35	5=,1,34,44,96,98
415550677	12,15,16,17,22,24,27,29,31,34,35	5=,17,20,34,35,46
415550929	12,15,16,17,22,25,27,29,31,34,35	5=,17,20,35,46,62
415594786	12,15,16,22,24,25,27,29,31,34,35	5=,17,20,34,35,62
415594912	12,15,16,22,24,26,27,29,31,34,35	5=,17,20,34,35,58
416964403	15,16,22,24,25,26,27,29,31,34,35	5=,20,34,35,58,62

laoau138

香川群子 发表于 2016-10-15 12:40
覆盖5组以上的共有74组：

放弃此条问题      

laoau138

today0427 发表于 2016-10-13 18:24
最痛苦的是，本来列个方程就能解决的问题，他偏不让你列，偏不让你列，眼看着你绕死在题目中不可自拔

VBA实现有2个条件组合输出

http://www.excelpx.com/thread-425085-1-1.html

laoau138

香川群子 发表于 2016-10-15 12:40
覆盖5组以上的共有74组：

VBA实现有2个条件组合输出

http://www.excelpx.com/thread-425085-1-1.html

hhzjxss

i没看懂是啥意思？？

laoau138

hhzjxss 发表于 2016-11-9 22:08
i没看懂是啥意思？？

完全不需要懂， 看不懂直接放弃就可以了