Thread: How do I return location (not value)of an Excel array's max value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bill Martin -- (Remove NOSPAM from address) Bill Martin -- (Remove NOSPAM from address) is offline
external usenet poster
  
Posts: 8
Default How do I return location (not value)of an Excel array's max value
Doug wrote:
How do I return the cell location (in addition to the value contained in the
cell) of the maximum value in an Excel array?

I'm trying to locate the row number for the maximum value in a column of
numbers.

The following will return the location of the max within the column. If it
returns "1" it's the first element of the array, and so forth.

[ ] = MATCH(MAX(A1:A10),A1:A10)

Bill
Reply With QuoteReply With Quote