View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alexandra Lopes Alexandra Lopes is offline
external usenet poster
 
Posts: 35
Default Order the names by ranking

Where I said order I meant sort

Alexandra Lopes wrote:
I have a list of collaborators with an associated classification. With
the function rank, I obtain the ranking of each one. And now I intend
that whenever it modifies the classification, that the names of the
collaborators are presented by order of ranking, automatically.

Somebody can help me?


Here's an example:


collaborators classification rank
galvao 75,8 8
pereira 70 11
ferreira 66 12
almeida 85 5
fournel 73,2 9
leal 62 17
rodrigues 55 18
hpereira 63 16
santos 64,5 15
jcruz 65 14
godinho 66 12
martins 88 2
amorim 86 4
mendes 80 6
nunes 87 3
ppereira 89 1
raposos 77 7
teixeiras 71 10





Thanks in advance!