MrExcel Publishing
Your One Stop for Excel Tips & Solutions

transposing cells

Posted by neil on March 30, 2000 1:46 AM

i have a sheet where i rank squash players by ability, what is a simple way to swap player rankings without copying each entry via a dummy cell


Posted by Tom Morales on March 30, 2000 5:57 AM

Presuming that you've assigned a numerical rank to each player, select your data area, including your ranking, and sort them by rank (Data/Sort).