Try...

=LOOKUP(2,1/(26:26=1),COLUMN(26:26))

....confirmed with just ENTER

OR

=MATCH(2,1/(26:26=1))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER

Hope this helps!

In article ,
"Karl" wrote:

Trying to figure a formula that will give me the column number of the last
column with data in a range. This is a sliding entry row where there may be
blanks at the begining and middle of the range.

Range is b26:m26 and may be as below:
0 0 1 1 0 1 1 0 0 0 0 0

I am looking to get colum 8 for use in an OFFSET lookup to other data in the
column.

I have tried no end of some of the suggested formulas in this forum but have
not gotten there yet.

Thank you