Last used column.

A

Andrew Mackenzie

Is there a way that I can make a cell reference the last occupied cell in a
row. I guess I could use =IF but there are too many columns to use nested
"IF"s.
 
B

Bob Phillips

This will get the column number

=MAX(IF(ISBLANK(1:1),0,COLUMN(1:1)))

it is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top