determining the last row in a linked excel sheet

paulmac

New Member
Joined
Nov 17, 2005
Messages
2
Hi,
I have an excel report sheet that gets it's value from the last row in a source sheet.
E.g today the value ='[Yield.xls]Class 1'!$I$1025
But in two weeks time the value could be =='[Yield.xls]Class 1'!$I$1099
I need to detrmine the last populated cell in column I on the linked sheet.
This seems so do-able,and efforts to resolve are wrecking my head.
Only one stipulation - I must not use VBA - otherwise I would have this resolved already as it is a no-brainer.
Thanks for any help/suggestions you may have to offer.
Paul
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
I think this is what you want :-

=LOOKUP(9.99999999999999E+307,I:I)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,030
Messages
5,569,757
Members
412,289
Latest member
Kingchaos64
Top