Hi everybody, this is my first visit and post on this forum!
Here is my question:
I've got an Array of Integers, DataInt(), with n rows and t columns. Columns are filled with values 1, 2 or 3. I need to compare all possible pairs of columns, in counting the 9 possible combinations (11, 12, 13, 21, 22, 23, 31, 32, 33).
I've written a macro which works fine, but slowly as I'm generally working with t around 10,000 and n around 200.
Does anybody have any trick to significantly fasten this macro. i, n and t are declared as Long (faster than Integer), along with DataInt().
Thanks in advance!
My code :
Bookmarks