I'm assuming that you want the cell address of the minimum value in a
column.

Since your dealing with a single, *known* column (Column I), I don't
understand why your calculating the second argument of the Address()
function.
Simply plug in "9" for the ninth column which is "I".

If my assumptions are correct, this should work for you:

=ADDRESS(MATCH(SMALL(I9:I373,COUNTIF(I9:I373,0)+1) ,I9:I373,0)+8,9)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"bookman3" wrote in message
...

Hi

{=ADDRESS(MIN(IF($I$9:$I$373=MIN($I$9:$I$373)*($I$ 9:$I$373<0),ROW($I$9:$I$373))),MIN(IF($I$9:$I$373 =MIN($I$9:$I$373)*($I$9:$I$373<0),COLUMN($I$9:$I$ 373))))}

This formula only works fine except when there are zeros in column I even
though the formula is looking at vlaues < 0
For example: rows 9 to 84 have values, rows 85 to 373 have 0.
The formula gives the result of I85.
If rows 85 to 373 are left blank the result is correct.

Can anyone help?
--
bookman