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?

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?

=A1-B1 and copy down.



--
Regards
Dave Hawley
www.ozgrid.com
"KTC53" <(E-Mail Removed)> wrote in message
news:2A5CB6D2-058C-4B2E-BCAC-(E-Mail Removed)...
> 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?