add reference numbers in column a tricky

Hi Experts excel 2007

I want to to add in cell a3 =a2+1 and scroll all the way down so I increment the numbers by 1. However, if I delete a8 row the formula below cell a8 come with #ref errors how do you get around this.
route217Asked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
Use this formula:

A3 = OFFSET(A3,-1,0)+1

By only referencing the same row the references won't get mangled when deleting rows.

Kevin
0
 
route217Author Commented:
Many thanks Kevin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.