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 |
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 |
find last none empty cell
thank you
works a treat kevin |
find last none empty cell
thank you
works a treat kevin |
All times are GMT +1. The time now is 06:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com