LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting data using numerical list Lyns Excel Worksheet Functions 1 March 7th 07 06:13 AM
Sorting data with an imbedded list Jasonw151 Excel Discussion (Misc queries) 1 December 14th 06 09:40 PM
Sorting Referenced Cells [email protected] Links and Linking in Excel 1 May 6th 06 12:44 PM
Sorting from a list with data on different cells Kiran Excel Discussion (Misc queries) 2 June 23rd 05 10:23 PM
Sorting referenced cells jcouncill New Users to Excel 2 December 21st 04 07:32 PM


All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"