A alldreams Feb 6, 2004 #1 How could I get a formula to work for the last non blank colum of a cell range? Any help will be greatly appreciated..
How could I get a formula to work for the last non blank colum of a cell range? Any help will be greatly appreciated..
F Frank Kabel Feb 6, 2004 #2 alldreams said: How could I get a formula to work for the last non blank colum of a cell range? Any help will be greatly appreciated.. Click to expand... Hi e.g. =COUNTA($A:$A) will give you number of non blanks within a row If you have no blank rows in between you can use =OFFSET($A$1,COUNTA($A:$A)-1,0) to get the last non blank cell HTH Frank
alldreams said: How could I get a formula to work for the last non blank colum of a cell range? Any help will be greatly appreciated.. Click to expand... Hi e.g. =COUNTA($A:$A) will give you number of non blanks within a row If you have no blank rows in between you can use =OFFSET($A$1,COUNTA($A:$A)-1,0) to get the last non blank cell HTH Frank
