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.
....
The following array formula is certain to work.
=MAX(IF(1-ISBLANK(B26:M26),COLUMN(B26:M26)))
|