Em Andamento

Macro to find sequential numbers in unsorted rows

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.

Habilidades: Excel, Visual Basic

Veja mais: you by your numbers, what is macro in excel, rows, midlander, macro e, excel macro combination, combinations macro, find user, excel macro row, combinations visual basic, combinations excel macro, excel 2013 macro, macro spreadsheet, excel macro combinations, visual basic six, combination macro excel, excel macro number combinations, sequential, excel combination, need macro excel, excel checks, rows cols, sequential excel, excel number combinations, need 300k

Acerca do Empregador:
( 2 comentários ) Sapcote, United Kingdom

ID do Projeto: #5120137