View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M John M John is offline
external usenet poster
 
Posts: 35
Default 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