No the nmubers are random, actually the column to the left is in date order
and this column has the amount relating to that date
--
bookman


"T. Valko" wrote:

Are your numbers sorted in descending order?

--
Biff
Microsoft Excel MVP


"bookman3" wrote in message
...
Hi

That works a treat.

I have 2 supplementary questions

If the same minimum value appears more than once in the list,how can I
find
the last entry?

I replaced SMALL with MAX. That worked but if there are more than 2
maximum
values in the list, how can I find the last entry?
--
bookman


"bookman3" wrote:


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