Lastinrow function

D

Denise

is there a function to have the last entry in a row on
sheet1 to auto-populate to a designated cell on sheet 2?
 
V

Vasant Nanavati

In the designated cell on Sheet2, use this array formula:

=INDEX(Sheet1!15:15,MAX(NOT(ISBLANK(Sheet1!15:15))*COLUMN(Sheet1!15:15)))

entered with <Ctrl> <Shift> <Enter>. This assumes you want the last entry in
row 15 on Sheet1.

No doubt there are easier ways.
 

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

Need Help with a VBA subroutine 0
Auto populate value from one task to another in MS PROJECT 0
Link a text box based on drop down box with four options MS Word 365 0
sum if last cell equals max row length 0
Excel - Wich Function should I use? 1
add hyperlink using sheet names and cells(i,j) 3
Referencing cells in consecutive rows 2
How do I clear a form? 0

Top