sorting and cell reference

V

vwchurch1955

I am trying to sort multiple columns, some of which have formulas i
them. The cell references change everytime I sort and I do not get th
results I expect. Can anyone tell me how to make the formulas refer t
the correct cells once they are sorted?

I appreciate anyones response. Can send file if need be.
Thank Yo
 
G

gocush

Your formulas have ABSOLUTE references to cells. (Ex: =$A$1). You
must change these to RELATIVE references: =A1


Here's the explanation:
Suppose before you sort, cell D5 has the formula =$A$1

After you sort, the former 5th row in now in the 2nd row, so what was
D5 is now B5 and it still is pointing to $A$1

Problem is: what was A1 is now A12 (it moved down in position)

By making your formulas RELATIVE they will "follow" the referenced cell
when sorted, or when a row is inserted or deleted.
 
P

Paul

vwchurch1955 said:
I am trying to sort multiple columns, some of which have formulas in
them. The cell references change everytime I sort and I do not get the
results I expect. Can anyone tell me how to make the formulas refer to
the correct cells once they are sorted?
Click to expand...

It depends on what you expected to happen. Perhaps you should use absolute
references such as $A$1 rather than relative ones such as A1. If this
doesn't solve your problem, post back with a simple example of a formula,
what happens when you sort and what you expected to happen.
 
Top