+ Reply to Thread
Results 1 to 2 of 2

Find the position of a value within an array

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 2010
    Posts
    24

    Find the position of a value within an array

    I have an array that I am trying to find the row and column position of the max value within that array.

    For example, if my array is E5:L11 and the max value within that array is located in cell G8 then I need a formula that can return the row number as 3 and the column number as 4.

    Any ideas...

    Thanks, Steven

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Find the position of a value within an array

    If there is possibility of duplicates in your data then this could fail.

    Row =MIN(IF(E5:L11=MAX(E5:L11),ROW(E5:L11)-ROW(E5:L5)+1))

    Column =MIN(IF(E5:L11=MAX(E5:L11),COLUMN(E5:L11)-COLUMN(E5:E11)+1))

    Both formula must be array confirmed with Shift Ctrl Enter.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1