Sorting list of referenced data
Hello,
I'm getting confused by how Excel is screwing this up. I have a list of
data, for example:
Score Name
5 John
2 Paul
6 Luke
The table is pulled from elsewhere in the Excel worksheet, such that the
above really looks like, for example:
Score Name
=A1 =B3
=A5 =B7
=A9 =B11
Excel keeps sorting this based on the cell references...so there's no change
in the sorting...what's going on?....how to fix?
Thanks,
MJohn
|