Thread: Finding Location of Maximum Value in 2D Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
[email protected] MajorSetback@excite.com is offline
external usenet poster
  
Posts: 6
Default Finding Location of Maximum Value in 2D Array
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.

Reply With QuoteReply With Quote