Excel Function - Please help

[Neil Hindry]

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!

 

[vezerid]

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

 

[Roger Govier]

Hi Neil
One way
=MAX(MATCH(LOOKUP(99^99,A:A),A:A),MATCH(LOOKUP(REPT("z",255),A:A),A:A))