|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 19th, 2010, 05:14 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculation
In one colum I have different years eg. 2009, 1979, etc.. In the next column
I have 2010. What I'm trying to do is subtract from each colum to show how many years a person has been in employment eg. 2009 joined company 2010 left company. I know I can do =2010-2009, but how do I drop the formula. I have tried putting in the colum eg. =a-b, but this doesn't work. If I do it the other way I have to do it individually. Can anyone help? 
|
|
#2
May 19th, 2010, 07:09 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculation
Hi,
not sure if I understood, in column A you have the year the person started and in column D the year he left the company so in column E enter =D1-A1 copy formula down "KTC53" wrote: In one colum I have different years eg. 2009, 1979, etc.. In the next column I have 2010. What I'm trying to do is subtract from each colum to show how many years a person has been in employment eg. 2009 joined company 2010 left company. I know I can do =2010-2009, but how do I drop the formula. I have tried putting in the colum eg. =a-b, but this doesn't work. If I do it the other way I have to do it individually. Can anyone help?
|
|
#3
May 20th, 2010, 01:13 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculation
=A1-B1 and copy down.
-- Regards Dave Hawley www.ozgrid.com "KTC53" wrote in message ... In one colum I have different years eg. 2009, 1979, etc.. In the next column I have 2010. What I'm trying to do is subtract from each colum to show how many years a person has been in employment eg. 2009 joined company 2010 left company. I know I can do =2010-2009, but how do I drop the formula. I have tried putting in the colum eg. =a-b, but this doesn't work. If I do it the other way I have to do it individually. Can anyone help?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
