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.