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.
 
Top