Looking up value
 

I am having a problem with a spreadsheet for portfolio values. The table is
layed out with each month being the next column. I want to find the min, and
then display the month that is associated with that minimum. I can't sort the
data since it is by month.

Looking up value
 

From a posting by Mike H. ONE line

=ADDRESS(MIN(IF(MIN(A2:E8)=A2:E8,ROW(A2:E8))),MIN( IF(MIN(A2:E8)=A2:E8,COLUMN(A2:E8))),4)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"D. Murphy" <D. wrote in message
...
I am having a problem with a spreadsheet for portfolio values. The table is
layed out with each month being the next column. I want to find the min,
and
then display the month that is associated with that minimum. I can't sort
the
data since it is by month.

Looking up value
 

I tried the formula and it didn't work. I can also do it in VBA if anyone
knows how to get me there. All I want to do is find the minimum portfolio
value and then offset a few rows up to get the date that the min occurred.

Looking up value
 

If desired, send you file to my address below and I will take a look. One of
the things I am is a retired regional manager for ING. As such, I once held
a series 7 license.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"D. Murphy" wrote in message
...
I tried the formula and it didn't work. I can also do it in VBA if anyone
knows how to get me there. All I want to do is find the minimum portfolio
value and then offset a few rows up to get the date that the min occurred.