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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Blank Page After Envelope-Label Wizard 5
Publisher adding blank page when printing my booklet... 2
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Mail Merge Switch - Dollars to Words 0
Non Commercial Use 3
Changing row background from external program 0
Formula than understands midnight? 26

Top