View Full Version : Sleeper: Last Row in closed workbook
mdmackillop
08-17-2005, 03:43 PM
Is there any way to determine the last row in column A containing data in a closed workbook. It is assumed that there may be gaps in the data.
Is there any way to determine the last row in column A containing data in a closed workbook. It is assumed that there may be gaps in the data.
and opening it and checking for the last populated cell in Col A is not allowed?
Jacob Hilderbrand
08-17-2005, 08:35 PM
Are we talking about numbers?
=MATCH(9.99999999999999E+307, 'C:\MyPath\[Book2.xls]Sheet1'!$A:$A,TRUE)
XL-Dennis
08-18-2005, 01:40 AM
No need to open it as Jake points out ;)
And for text values You can test to use:
=MATCH(REPT("z",255), 'C:\MyPath\[Book2.xls]Sheet1'!$A:$A,TRUE)
Kind regards,
Dennis
Bob Phillips
08-18-2005, 03:36 AM
No need to open it as Jake points out ;)
And for text values You can test to use:
=MATCH(REP("z",255), 'C:\MyPath\[Book2.xls]Sheet1'!$A:$A,TRUE)
Typo, should be
=MATCH(REPT("z",255), 'C:\MyPath\[Book2.xls]Sheet1'!$A:$A,TRUE)
For mixed values, try
=LOOKUP(2,1/(1-ISBLANK( 'C:\MyPath\[Book2.xls]Sheet1'!A1:A65535)),( 'C:\MyPath\[Book2.xls]Sheet1'!A1:A65535))
XL-Dennis
08-18-2005, 05:01 AM
Typo, should be...
Thanks and FYI, REP is the Swedish name for the REPT-function. You guys with English as the first language have it much more easier then the rest of us ;)
Kind regards,
Dennis
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.