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?
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
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)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks