Hi how to address all cells in column excluding first n cells in that colum Than alekm
G Guest May 17, 2004 #1 Hi how to address all cells in column excluding first n cells in that colum Than alekm
J Jason Morin May 17, 2004 #2 Do you mean put the actual cell address in the cell? If so, try: =IF(ROW()<n,"",ADDRESS(ROW(),COLUMN(),4)) where n = last row to exclude. HTH Jason Atlanta, GA
Do you mean put the actual cell address in the cell? If so, try: =IF(ROW()<n,"",ADDRESS(ROW(),COLUMN(),4)) where n = last row to exclude. HTH Jason Atlanta, GA
F Frank Kabel May 17, 2004 #3 Hi something like =SUM(OFFSET($A$1,10,0,1000)) to exclude the first 10 cells?
P Peo Sjoblom May 17, 2004 #4 One way OFFSET(A1,10-1,,65536-10+1) will be A10:A65536, you can obviously replace 10-1 with 9 and 10+1 with 11
One way OFFSET(A1,10-1,,65536-10+1) will be A10:A65536, you can obviously replace 10-1 with 9 and 10+1 with 11