find last none empty cell

Hi
i have a worksheet that allows the user to enter data over a range
C27 : Z27
What i want to do is check the range and return the last cell that
contains a value
i have tried several formulas but am getting lost
this formula below is the closest i can get to resolving the problem

=ADDRESS(ROW(A5),MATCH(<>" ",A5:E5))


can anyone help please

thanks

kevin

=ADDRESS(ROW(A5),MAX(IF(ISBLANK(C5:Z5),0,COLUMN(C5:Z5))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kevcar40" <[email protected]> wrote in message
news:[email protected]...
> Hi
> i have a worksheet that allows the user to enter data over a range
> C27 : Z27
> What i want to do is check the range and return the last cell that
> contains a value
> i have tried several formulas but am getting lost
> this formula below is the closest i can get to resolving the problem
>
> =ADDRESS(ROW(A5),MATCH(<>" ",A5:E5))
>
>
> can anyone help please
>
> thanks
>
> kevin
>

thank you
works a treat

kevin

thank you
works a treat

kevin