Formula to always pick the last row

[vinaya nayak]

Hi,

I have a file which is linked with another one and is updated one
line,everyday.
Is there a formula which helps me always link the last line in the file?

Regards,
Vinaya.

 

[Govind]

Hi vinaya,

If you want the last cell where the updation has taken place, then you
can try this

=ADDRESS(ROW((OFFSET(A1,MATCH("z",A1:A100)-1,0))),1)

This assumes that the data is in column A and starts at A1. If not,
adjust the formula accordingly.

Regards

Govind.

 

[Arvi Laanemets]

Hi

When data in Sheet1 of source workbook (placed in folder C:\My Documents in
my example) start from A2 (1st row are headers), then to retrieve the entry
from last row in column A, into some cell in column A of target workbook
enter the formula:

=OFFSET('C:\My Documents\[SourceWorkbook.xls]Sheet1'!$A$1,COUNTIF('C:\My
Documents\[SourceWorkbook.xls]Sheet1'!$A:$A,"<>")-1,ROW()-1)
and copy it right for as many columns as exist in target table.
PS. This works, when there are no empty cells between filled ones in column
A of source table.

 

[Govind]

Hi,

Just to clarify, i had assumed you had only text numbers in Column
A.When you have numbers, use this formula

=ADDRESS(ROW((OFFSET(A1,MATCH(9.99999999999999E+307,A1:A100)-1,0))),1)

Regards

Govind.