non blanks

A

alldreams

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

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
 
Top