Forum Discussion
Solved
Comparison of arrays with different dimensions
So, I wanted to fully understand how Excel compares arrays and encountered quite strange behaviour. Here are the cases I tested: 1) Comparison of arrays of any size and single cell - works pretty cl...
Resulting array always have maximum number of rows/columns of source arrays. If we compare 1D array, i.e. single row or column or in particular single cell, it iterates through rows/columns of 2D array. If both source arrays are 2D it compares elements from left to right and from top to bottom returning #N/A when we out of size of the one of arrays.
Resulting array always have maximum number of rows/columns of source arrays. If we compare 1D array, i.e. single row or column or in particular single cell, it iterates through rows/columns of 2D array. If both source arrays are 2D it compares elements from left to right and from top to bottom returning #N/A when we out of size of the one of arrays.