Excel relative cell referenc lost while sorting

J

jracine

in a spreadsheet, in cell "A10", I'm making a relative reference to "A1
which shows "Oct 21, 2004" formatted as date number. When I sort th
columns into another order, the actual relative reference doesn'
follow the "Oct 21, 2004" and the relative cell reference gets anothe
cell which for example might have "October 15, 2004"
How do I ensure that even through a sort, my original reference cel
isn't lost
 
S

SPenney

Let me re-state to ensure I understand...

For instance B1 refers to A1. After the sort, B1 is now B12 and refer
to A12.

If this is happening you should try using absolute references. Whe
entering the cell reference, you can hit F4 to cycle through th
options.

If this isn't what is happening, sorry I didn't understand better.

Stacie
 
R

Richard O. Neville

You could make the reference absolute, as "$A$1". Then, no matter where the
original A1 might have moved, the reference will still be to that data, in
this case a date. The cell containing the reference must be date-formatted
itself.
 
Top