find last none empty cell
=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" wrote in message
oups.com...
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
|