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
...thanks
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).
