+ Reply to Thread
Results 1 to 2 of 2

Function to determine cell location

  1. #1
    Registered User
    Join Date
    08-14-2010
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    1

    Function to determine cell location

    I have a column of data and I use the MIN function to find the lowest value in the column. I also want a function that will return the cell location that the lowest value is in. Is there a function for this?
    Last edited by jcg61; 08-14-2010 at 09:32 PM. Reason: update title

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

    Re: Function to determine cell location

    If as you imply you're working with a single column then use the MATCH of the MIN as the basis for identifying the row
    That value in conjunction with the column number will give you the cell address should you really need it.

    eg say numbers of interest are in AA100 to AA200 then the address of the MIN can be returned using:

    =ADDRESS(MATCH(MIN(AA100:AA200),AA100:AA200,0)+ROW(AA100)-1,COLUMN(AA100))

    modify ranges to suit
    (there are countless alternative approaches)

+ 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