Excel VBA Course
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.)

View Course

Need Code or know how to delete rows of lottery combinations that meet a certain criteria

0

I'm trying to minimize the number of combinations I have for a specific lottery game in the U.S. At the moment I want to delete rows that have more than 3 odd numbers or more than 3 even numbers. I would also like to delete rows that have four or more consecutive numbers. For example 20 21 22 23 would be deleted. Please note that all combinations are in one cell. Thanks.

Answer
Discuss

Discussion

I didn't fully understand if the 20 21 22 23 are in one cell or 20 in cell and 21 in another cell ...
MRVMV (rep: 52) Jul 21, '16 at 8:16 am
20 21 22 23 in the same cell
jdvarner Jul 21, '16 at 8:27 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login