F
fireflyrt
The Match function seems to work only on 1 dimensional arrays. Is there any
such function that returns the cell reference for a match in a 2d array?
For example, I am trying to find the cell location of a max number in a
1000x1000 array of data - is there a function that will do that?
such function that returns the cell reference for a match in a 2d array?
For example, I am trying to find the cell location of a max number in a
1000x1000 array of data - is there a function that will do that?