Sort of cells referencing other cells not in the right sort order

[David Abbott]

Example
Cell A1 = 1
Cell A2 = 2
Cell A3 = 3

Cell A4 = +A
Cell A5 = +A
Cell A6 = +A

Sorted Decending equals
2
1
3

Any ideas

 

[Bob Umlas Excel MVP]

You should not sort a range containing formula which refer
to cells in rows other than its own. A3 (35) will sort to
A1, A6, containing 35 will sort to A2, but the formula
says "3 rows up). From A2, that gives a #REF error, etc.

 

[David Abbott]

I am only sorting Rows A4 through A6 in Decending order. Are you telling me that because I have a cell references out in cells A1 through A3 that there is no way to sort it because of the way Excel does cell references

----- Bob Umlas Excel MVP wrote: ----

You should not sort a range containing formula which refer
to cells in rows other than its own. A3 (35) will sort to
A1, A6, containing 35 will sort to A2, but the formula
says "3 rows up). From A2, that gives a #REF error, etc