On Oct 13, 1:23*pm, "joeu2004" wrote:
If you highlight and sort C1:C2 ascending,
it does not sort as desired.

Change the formulas to use A$1 and A$2 (or $A$1 and $A$2), and it will work
as you expect.

The way I would accomplish that is by copying =A1 down and doing a
search and replace
A - A$
over the range. While clunkier than copying by value, I like that it
would then be self-maintaining; if the "source" data ever changed
(i.e. column A in my example), I could sort with no additional work.
Excellent suggestion.