find last none empty cell

  • Thread starter Thread starter kevcar40
  • Start date Start date
K

kevcar40

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Average cells based on column header 6
Sum multiple sheets? 1
last value 6
Function to Return a Date Value Q 4
Last Modified By in a cell by user 3
Excel VBA 1
automatically average the last 4 columns 10

Back
Top