Neil,
you can use this array formula (commit with Ctrl+Shift+Enter)

=ADDRESS(MAX(IF(A1:A1000<0,ROW(A1:A1000)),_column _)

For _column use the number of the column where data is located.

HTH
Kostis Vezerides

Neil Hindry wrote:
From a cell I want to find out what is the first cell going upwards in the
same column that is not empty or does not contain a zero value.
I don't want to know the value I want the cell reference so I can use it in
a formula.

Does anyone know how I can do this in Excel 2003?

I hope you can help me.

I appreciate any help or information given.


Thanks!