Sort Rows in order and re-align cross table

M

Mickey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to sort rows getting hung up by merged cells 0
help with ranking in a query 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Sort partially hidden data 1
Sorting rows out of order after all rows are numbered in sequence 1
SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as perdescending order of salary 0
Find Specific Rows in Range and Create New Tab 18
Create a new sheet dependant on values 1

Top