Referring to a portion of a column


L

LewisM

Knowing that $A:$A can be used in a worksheet function to refer to all cells
in column A. Is there a way to refer to all cells below a starting point?
(i.e., I want to CountA() all cells below my header rows). I can't just
subtract the number of header rows because the CountA() of those varies.
 
Ad

Advertisements

D

Don Guillett

The best way to do this is to make a self adjusting defined name range
insert>name>define>name it something like colA
in the refers to box
=offset($a$1,0,0,counta($a:$a),1)
 

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

Top