Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
transposing cellsPosted 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
Re: transposing cellsPosted 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).
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.