+ Reply to Thread
Results 1 to 3 of 3

Locating Minimum value, output additional data

  1. #1
    Registered User
    Join Date
    06-27-2009
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Locating Minimum value, output additional data

    Hello, I'm having an issue trying to find a minimum value. What I'm attempting to do is have a formula output the cell coordinates of this minumum value and then use those coordinates to return the data in the row below the minimum value.

    What I have right now is a formula that returns the coordinates of the minimum value of a row =CELL("address",OFFSET(A1,0,MATCH(MIN(A1:N1),A1:N1,0)-1)) and it outputs $[ROW]$[COLUMN]. I would like to take the $[ROW]$[COLUMN] coordinates and use a formula to output the data contained in the cell $[ROW-1]$[COLUMN]

    Does that make any sense? Is it possible?

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Locating Minimum value, output additional data

    As I see it... no need for all that...

    =INDEX(A2:N2,MATCH(MIN(A1:N1),A1:N1,0))

  3. #3
    Registered User
    Join Date
    06-27-2009
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Locating Minimum value, output additional data

    EDIT: Never mind, it works perfectly! Thanks!
    Last edited by bucklj2; 06-27-2009 at 01:49 PM.

+ 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