Remove number sequences

[mvtpinheiro]

Hello,



I have a spreadsheet with multiple tabs that lists (via Macro) all possible combinations for 15 numbers out of 25 numbers (3 million+ results - 230Mb xls), where each number is on cell.
Now I want to clean up this list removing all the combinations that have more than 6 numbers in sequence (actually replace the cells with blank).

For example:

1, 2, 3, 4, 5, 6, 7, 10, 14, 15, 17, 22, 23, 24, 25 - since we have 7 numbers in sequence (1 to 7), I would like to replace all 15 cells in this row with blanks.

Also, I would like to remove some patterns, for example:

1, 3, 5, 7, 9, 11, 13, 15, 17, 18, 19, 21, 23, 24, 25 - since we have 1 to 17 skipping one number (than I would select the patterns I don't want and replace all 15 cells with blanks too).

Any ideas??

Tks, Marcus