Last cell in range

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

Is is possible to have a sheet read the last cell with
data in a range for example

range A1 : A30 may have 4 lines of data , I would like
cell on another page to read the data from A4

When I enter data in to A5 i would like the cell to
update to the data in cell 5 and so on and so forth.

Thanks in advance
 
Graham,

Try this

=INDEX(A:A,MAX(IF(A1:A32<>"",ROW(1:32))))

it's an array formula, so commit with Ctrlo-Shift-Enter, not just Enter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Graham said:
Is is possible to have a sheet read the last cell with
data in a range for example

range A1 : A30 may have 4 lines of data , I would like
cell on another page to read the data from A4

When I enter data in to A5 i would like the cell to
update to the data in cell 5 and so on and so forth.
Click to expand...

Try

=LOOKUP(9.99999999999999E+307,1/(1-ISBLANK(A1:A30)),A1:A30)
 
Back
Top