Thread: Match function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fireflyrt fireflyrt is offline
external usenet poster
 
Posts: 2
Default Match function

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?