Excel formula copying
#1
Scooby Regular
Thread Starter
Join Date: Oct 2000
Location: same time, different place
Posts: 11,313
Likes: 0
Received 4 Likes
on
2 Posts
Anyone help please? I have to copy a formula in which one cell changes and the other stays the same.
So I have an official date (cell A1) by which time countries should have done something - a deadline.
I then have a list of dates by which the different countries actually did it:
Andorra (A2)
Afghanistan (A3)
Austria (A4)
Etc.
Beside each country I would like to calculate the time delay:
So that would be
B2=A2-A1
B3=A3-A1
B4=A4-A1
Etc
If I simply drag the top formula down, it copies the pattern of the formula for BOTH cells, thus:
A2-A1
A3-A2
A4-A3
Can anyone tell me an easy way of how to copy/predict/paste the formula that I want, without manually changing the second cell all the way down the column?
Many thanks
Brendan
So I have an official date (cell A1) by which time countries should have done something - a deadline.
I then have a list of dates by which the different countries actually did it:
Andorra (A2)
Afghanistan (A3)
Austria (A4)
Etc.
Beside each country I would like to calculate the time delay:
So that would be
B2=A2-A1
B3=A3-A1
B4=A4-A1
Etc
If I simply drag the top formula down, it copies the pattern of the formula for BOTH cells, thus:
A2-A1
A3-A2
A4-A3
Can anyone tell me an easy way of how to copy/predict/paste the formula that I want, without manually changing the second cell all the way down the column?
Many thanks
Brendan
#3
B2=A2-$A$1
..the $ 'anchors' the row or column after it,and makes it a actual rather than relative reference - so it doesn't change when you copy it
Exercise for the student:
- play with B2=A2-A$1 and B2=A2-$A1..thy're not what you want, but you can see the effect
Martin
Edit: Damn - beaten to it
[Edited by MartinM - 10/15/2003 11:52:31 AM]
..the $ 'anchors' the row or column after it,and makes it a actual rather than relative reference - so it doesn't change when you copy it
Exercise for the student:
- play with B2=A2-A$1 and B2=A2-$A1..thy're not what you want, but you can see the effect
Martin
Edit: Damn - beaten to it
[Edited by MartinM - 10/15/2003 11:52:31 AM]
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM