Identifying Last Column With Text

S

stan

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
 
L

Luke M

=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.
 
Top