: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find last number in a column with numbers
Here's how you create the named range
=OFFSET(Sheet1!$B$1,1,,MAX((LEN(TRIM(Sheet1!$B$1:$B$200))>0)*(ROW(Sheet1!$B$1:$B$200)))-1,1)
Check the attachment
Regards,
Sam Mathai Chacko (GL)
Hello Ken;
Also, =MATCH(9E300,A:A) will give the last row number contains number. so
you can define name range with this as length
See the attached. Same data as Sam posted.
HTH
Haseeb
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor th
msg
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Ken
> Sent: Thursday, October 27, 2011 1:54 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Find last number in a column with numbers
>
>
> I have two
Attach your file with a copy of this msg
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Ken
Sent: Thursday, October 27, 2011 1:54 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Find last number in a column with numbers
I have two columns of
I have two columns of numbers. Column A is sequential dates. Column
B is data gathered from time to time and entered in the appropriate
date row as related to Column A. Column B has lots of blank rows
without data. Reason: I do not gather data each day. All the rows
below the last entry in Co
