All Questions
4 questions
7
votes
1
answer
217
views
Sudoku-lite challenge
You can find the problem here.
The example:
Column A, B, and C are each 3 and together equal 9:
...
4
votes
3
answers
655
views
Sub that compares 2 columns fast
This is an answer to this SO question: Vba comparing 2 columns of data.
In that question the OP code is very slow (also not working properly but the problem is fixed)
I spent some time to ...
10
votes
3
answers
1k
views
Cleaning up and reformatting imported data in an Excel sheet
The code below was refactored for performance improvements for another user on this site.
Functionality, high level:
Sheet1 - CodeName aIndex: used as the main reference to the structure of the data ...
12
votes
2
answers
391
views
Calculation of an inflation on volume/year
I would like to find out if my current solution to the problem described below is "good enough" or if there is an alternative way of achieving it. All I care about is the length (no. of ...