Skip to main content
The 2025 Developer Survey results are in. Explore insights into technology and tools, careers, community and more. View results.

All Questions

Filter by
Sorted by
Tagged with
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: ...
learnAsWeGo's user avatar
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 ...
paul bica's user avatar
  • 1,174
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 ...
paul bica's user avatar
  • 1,174
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 ...
user avatar