Sort Data Using Formula To Find Top X

[mahmoud-lee]

I want to arrange the names depending on the total from high to low
To became look like the first list

[Rick Rothstein]

I want to arrange the names depending on the total from high to low
To became look like the first list

Oh, you showed the list backwards from what I was expecting. Okay, your out-of-order list is in cells A17:C29... Select that range, then click Data/Sort in your XL2003 worksheet, select "Ranking" from the first drop-down box (labeled "Sort by") and select the option button labeled "Ascending" next to it... make sure the option button on the bottom labeled "Header row" is selected (it should be by default) and then click the OK button.