[users] formula: making the column number move with the calc sheet

I have a formula: =INDIRECT(ADDRESS(COUNTA(O1:O65364);15)) This gets the last value in the column (works great!) But, if I add a column (L) to the left of this column the column count # (15) doesn't get updated (to 16) as the column (O) does.(P1:P65634) Makes for an erroneous formula. Fix?? --

Re: [users] formula: making the column number move with the calc sheet

Hi Greg, Use the 'column' function to get the column number. =INDIRECT(ADDRESS(COUNTA(O1:O65364);column(o1))) tc GregChi wrote: I have a formula: =INDIRECT(ADDRESS(COUNTA(O1:O65364);15)) This gets the last value in the column (works great!) But, if I add a column (L) to the left of this colu