Change the formulas to
=A$3 and
=A$2



"zxcvbnm6000" wrote:

I have a Excel sheet with various data that I want to sort by A-Z, the
problem is I have equations the do not sort correctly.

Example:
Befo
A1 - Mouse B1 - (=A3)
A2 - Dog B2 - ***
A3 - Cat B3 - (=A2)

After A-Z Sort:
A1 - Cat B1 - (#REF)
A2 - Dog B2 - ***
A3 - Mouse B3 - 0

Please help. This should be simple, but I just can't make it work.