Ranking by percentage

[Guest]

How can you rank by percentage alone? I have a table of players stats that
are rated using percentages and i would like to have the table automatically
rank them desceding as the sheet is updated.

 

[Guest]

Hi,

One way is to use the Sort command under the Data menu.

Challa Prabhu

 

[Guest]

Here is a very simple example. The player's names are in column A and the
percentages are in column B. Enter this macro in Worksheet code:


Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("B:B"), Target) Is Nothing Then
Exit Sub
End If
Application.EnableEvents = False
Set r = Range("A:B")
r.Sort Key1:=Range("B1"), Order1:=xlDescending
Application.EnableEvents = True
End Sub

Anytime you change a percentage in column B, the list will re-sort itself in
descending order. It's automatic and requires no formulas at all.


REMEMBER: Worksheet code.