Identifying Last Column With Text
 

Hello,

How can I come up with a formula to have excel recognize the last column
with text? I want to find the last column of text and do a sum if using
offsets based off the last column.

Thanks,
Stan

Identifying Last Column With Text
 

=MAX(IF(ISTEXT(A1:Z100),COLUMN(A1:Z100),0))
Enter this using Ctrl+Shift+Enter. This will return numerical value of last
column with text within the range. (A=1, B=2, etc)

You could of course insert this bit of the formula into your offset formula
somehow to get your final desired results.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"stan" wrote:

Hello,

How can I come up with a formula to have excel recognize the last column
with text? I want to find the last column of text and do a sum if using
offsets based off the last column.

Thanks,
Stan