Not likely, but if there are finding the first one would suffice. FYI I've
had to split up the array into 250x4000 to allow it to fit within the 256
column limit

"T. Valko" wrote:

1000x1000 array

That's 1 million cells. Are there any duplicates?

--
Biff
Microsoft Excel MVP


"fireflyrt" wrote in message
...
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?