Excel – Get Top Row of a Multi Row / Mult Column Range
=VLOOKUP and =INDEX(MATCH(),MATCH()) are well known formulas, if you need to get some value corresponding to another …
Excel – Get Top Row of a Multi Row / Mult Column Range Read more →
=VLOOKUP and =INDEX(MATCH(),MATCH()) are well known formulas, if you need to get some value corresponding to another …
Excel – Get Top Row of a Multi Row / Mult Column Range Read more →
So, the idea is the following – imagine that you have an NxN range, which should …
Formatting a substring of a string in an Excel Cell is actually quite a challenging task. …
Changing tab color of Excel is somehow useful. With VBA, it is easily programmed, as far …
Selecting multiple cells in Excel through VBA may be quite a difficult task. Although, using Select is …
Excel and VBA are a powerful tool for simulation. The idea is to simulate dice throwing …
Markov model is a a stochastic model describing a sequence of possible events in which the …
The worksheet events which are built within VBA are quite useful. One may build them quite …
VBA – How to Change Merged cell in Excel with Events Read more →
There is an ERP joke, claiming that the third most popular button of an ERP system …
.Net – Reading Excel file in C# and transferring it to a matrix Read more →