Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Sort Rows in order and re-align cross table

Hi,
I use Excel to maintain a large number of tournament templates. The
templates record 'All Play All' matches. All players are placed in Rows
whilst the rounds are placed in columns. I can easily RANK the players by
score but also need to re-order the players so that after each result, the
players are listed in order of score. The difficult part is that each
column then needs to be re-aligned to that each player is still shown in the
correct order by column as well as row.

I understand that first I must sort the rows but the difficult art is then
sorting the columns. I'd appreciate any ideas how this is done.

Thanks,
Mickey


Reply
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
Pivot table sort order Michelle Excel Discussion (Misc queries) 2 July 20th 09 02:06 PM
Pivot Table Sort Order Mustang Excel Discussion (Misc queries) 1 May 4th 09 12:30 PM
Pivot table sort order ajnmx Excel Worksheet Functions 1 March 27th 07 10:39 PM
Sort order not being matched in pivot table Deanery Phil Excel Discussion (Misc queries) 2 January 8th 07 08:34 AM
Pivot table sort order Vincdc Excel Discussion (Misc queries) 2 March 1st 06 05:20 PM


All times are GMT +1. The time now is 02:58 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"