Prev: Sum If ???
Next: Block a excel file from being copied?
From: Mafukufuku on 7 Apr 2010 06:28
Hi, I am working through a long worksheet with data. It is made for me by
someone else. It has about 2300 rows. In Column C are measuring results,
Bottom field of this column(C2300) has the median of this column. Column D
has for every row the function =(C1-C2300) to measure the difference of that
value to the median of the column. But in column D the maker uses this
notation: =(C1-$C$2300)
\
Why the dollar signs? Is it to be able to pull the function down over the
whole column D of 2300 fields without C2300 changing into C2301 C2302 etc?
Thanks
From: trip_to_tokyo on 7 Apr 2010 06:40
It fixes that particular cell so that it you copy it to elsewhere that cell
reference ($C$2300) will remain the same (it will not change as it is moved).

If my comments have helped please hit Yes.

Thanks.



"Mafukufuku" wrote:

> Hi, I am working through a long worksheet with data. It is made for me by
> someone else. It has about 2300 rows. In Column C are measuring results,
> Bottom field of this column(C2300) has the median of this column. Column D
> has for every row the function =(C1-C2300) to measure the difference of that
> value to the median of the column. But in column D the maker uses this
> notation: =(C1-$C$2300)
> \
> Why the dollar signs? Is it to be able to pull the function down over the
> whole column D of 2300 fields without C2300 changing into C2301 C2302 etc?
> Thanks
From: trip_to_tokyo on 7 Apr 2010 06:43
It fixes that particular cell so that IF you copy it to elsewhere that cell
reference ($C$2300) will remain the same (it will not change as it is moved).

Sorry for error in earlier posting.


"Mafukufuku" wrote:

> Hi, I am working through a long worksheet with data. It is made for me by
> someone else. It has about 2300 rows. In Column C are measuring results,
> Bottom field of this column(C2300) has the median of this column. Column D
> has for every row the function =(C1-C2300) to measure the difference of that
> value to the median of the column. But in column D the maker uses this
> notation: =(C1-$C$2300)
> \
> Why the dollar signs? Is it to be able to pull the function down over the
> whole column D of 2300 fields without C2300 changing into C2301 C2302 etc?
> Thanks
From: ozgrid.com on 7 Apr 2010 07:49
Read up on why here
http://www.ozgrid.com/Excel/free-training/excel-lesson-16-basic.htm
after that;
http://www.ozgrid.com/Excel/excel-fill-handle.htm


--
Regards
Dave Hawley
www.ozgrid.com
"Mafukufuku" <Mafukufuku(a)discussions.microsoft.com> wrote in message
news:6484305E-A1F8-4182-94B5-9D1EC0526119(a)microsoft.com...
> Hi, I am working through a long worksheet with data. It is made for me by
> someone else. It has about 2300 rows. In Column C are measuring results,
> Bottom field of this column(C2300) has the median of this column. Column
> D
> has for every row the function =(C1-C2300) to measure the difference of
> that
> value to the median of the column. But in column D the maker uses this
> notation: =(C1-$C$2300)
> \
> Why the dollar signs? Is it to be able to pull the function down over the
> whole column D of 2300 fields without C2300 changing into C2301 C2302 etc?
> Thanks

 | 
Pages: 1
Prev: Sum If ???
Next: Block a excel file from being copied?