Hi,
Take a look at the sumproduct function

http://www.xldynamic.com/source/xld.SUMPRODUCT.html


"fireflyrt" wrote:

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?