On the only sheet in the attached workbook are 3 buttons:
1. In the vicinity of cell T1: Click to populate column K with all possible combinations of the numbers 1 to 35 in sets of 5. This is just to keep the file size small for attaching. Here, it takes less than a minute to run. Every cell is unique.
2. A button labelled '1.' This matches only the 5 numbers, in sequence, taking a leaf from Paul's procedure. It assumes all cells in column G contain 5 numbers, ascending left to right. When run it adds hyperlinks to columns G and K; click on a cell in column G and it takes you to a cell in column K. Click that cell in column K and it takes you back to the cell in column G. This assumes no repeats in column G. If there are repeats, clicking a cell with a hyperlink in column K takes you to the first cell with that combination in column G. The hyperlinks are obvious from their colour and underlining (the exact highlighting can be tweaked). This is the only way that the cells are highlighted in this procedure. It's quite quick. It requires all cells in column G to have ascending numbers left to right. If this is not the case, then the cell in column G is coloured grey (well, the sequence not found in column K).
3. A button labelled 2. This checks for matches of 3 and 4 numbers (not 5 numbers). It is slow. Here, about 7 seconds per cell in column G. It colours the cells, and adds formulae to column N to allow Trace Precedents. I've ditched that for column G.
Both buttons 1. and 2. ask if you want to clear things; if you say 'yes', highlighting or hyperlinks are removed and the data is treated as never having been processed. The idea is to save time by skipping over already-processed cells when you add data to column G by saying 'no' to the question.
Last edited by p45cal; 03-27-2017 at 03:40 PM.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote