Spreadsheet has up to 300k rows of unique combinations of numbers in Cols C - H
The six numbers in each row may be "unsorted (e.g. "3 - 8 - 11- 4 - 21 - 17")
User decides whether to clear contents of rows containing two or three sequential numbers.
Need Macro that checks each combination, and clears those that contain the number of sequences selected by the User.
So if the User selected "2 sequential numbers", it would clear the example because the combination contains sequential numbers 3 and 4.
But if the user selected "3 sequential numbers" it would NOT clear the selection, because there are not three sequential numbers in the combination.
PLEASE do not waste your time or bids if you cannot solve this. Any submissions that do not do what is required will be discarded immediately.