View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default Sorting names and numbers in order with the highest total

Select the columns with the data and then Data==Sort=Sort by <Select your
column Option "Descending" and repeat for other columns if required.

HTH

"Red Shoes" wrote:

I would like to set up a spreadsheet with names down the left column and
different numbers next to each person. How do you sort this in order of
highest total from top to bottom so that each person numbers move when its
sorted so the highest total is at the top.