If your data is in B1:C202 then...
In A1 =MAX(B1:C202)
In E1 =IF(ISERROR(MATCH(A1,B1:B202,FALSE)),ADDRESS(MATCH (A1,C1:C202,FALSE),3),ADDRESS(MATCH(A1,B1:B202,FAL SE),2))
Gives you the cell location of the maximum value.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
wrote in message
I am using MS Office ExCel 2003(11.6560.6568) SP2 and have a single
sheet with a 2D array of numbers roughly 202x202 in size. Could
someone tell me the quickest way to locate the maximum value in the
array? I tried =WhereMax("Sheet1") but just got #NAME? as the result.
Any assistance would be greatly appreciated,
Peter.