Two recent instances required transferring data from one array to another. One was a solution to speed up the use of COUNTIF for each element in a large range testing against another large range. In the process I had to build several building blocks including a replacement for the native Excel TRANSPOSE function, [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/10/26/a-quick-tip-working-with-arrays-with-unknown-bounds/
Posted
Oct 27 2009, 12:49 AM
by
Daily Dose of Excel