Z
zxcvbnm6000
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:
Before:
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.
problem is I have equations the do not sort correctly.
Example:
Before:
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.