Fast serarch of 2 dimensional array
- by Tim
I need a method of quickly searching a large 2 dimensional array. I extract the array from Excel, so 1 dimension represents the rows and the second the columns. I wish to obtain a list of the rows where the columns match certain criteria. I need to know the row number (or index of the array).
For example, if I extract a range from excel. I may…