How to create exceptions in a generation of defined sequences?
I have more than three million generated numbers but I want to refine by putting some exceptions to not being visualized.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Exceptions
0
Answers
0
3 million sounds like a lot to me. If we are talking about the same thing, just output the current list into Excel, use a formula to identify any exceptions that you want and then another formula to create the new list and them import that list into the Custom List window.
0
There are 3 million combinations of 15 numbers out of a total of 25 numbers.
It is a combinatorial analysis
And I wanted excel to select within these 3 million exceptions that I would report should not occur.
Discussion
Please follow the rules and edit your original question to include this information. Also if you have a sample sheet showing how you select numbers from the 3 million that would help (dont include all 3 million values though).
don (rep: 1989) Feb 4, '17 at 10:28 pm
Hi, look example
Combinations are generated by "combinatorial analysis".
But it shows all the possibilities of
15 numbers within 25 possible. I want to define several filters ... type prime numbers,
sum of seria, sum of numbers ..... anyway, I wanted to
create several filters in
VBA code so that this listing
is much smaller.
edgolveia Jan 18, '18 at 1:34 pm
You need to update your original question with new information, otherwise it is difficult for visitors to follow what is going on.
don (rep: 1989) Jan 20, '18 at 8:32 am