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?? -- Greg Agent 1.93/32.576 Opera8.5 OOo2.0 Eudora(NG7)6.2.5.6 news.readfreenews.net & news.gmane.org Win98se for sale: Apple//,Auto Parts/Equip/Manuals: geardocATgeardoc36DOThostingisfreeDOTcom
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
