1

Selecting a range of definite size (e.g. A1:A2) works just fine, but selecting a range to the last row does not. If relevant, I am using Office 365.

Error in formula

Improve this question
2
  • 1
    Excel does not accept open ended range references like A1:A . One must state the ending row or full column reference.
    – Scott Craner
    Commented Dec 14, 2020 at 19:22
  • @ScottCraner it accepts that in array formulas
    – phuclv
    Commented Dec 15, 2020 at 0:40

2 Answers 2

Reset to default
2

You can do open references like A:A or 1:1 but cannot mix and match the fixed and open references. To reference the last non-blank cell:

=INDEX(A:A,COUNTA(A:A))

Or the whole non-blank range:

=A1:INDEX(A:A,COUNTA(A:A))
Improve this answer
0

Change the C1:C to C:C, it will work for you.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .