Ranking in alphabetical order

**Gearcutter** · 11-06-2006, 04:05 PM

Hi Everyone, I have several lists of names in a column with spaces I would like to rank the list in alphabetical order is this possible?
Regards Howard

**VBA Noob** · 11-06-2006, 04:11 PM

Can you post an example of ranges and gaps and expected result.

VBA Noob

**Gearcutter** · 11-06-2006, 04:28 PM

Hi my hobby is producing spreadsheets that are soccer related. in this case i have produced a squad list of footballers for each team in the Premiership in squad order. What I want to do is give each name a number based on the alphabet, as of yet I Have not found a function that will do this for me.
Regards Howard

**VBA Noob** · 11-06-2006, 04:34 PM

How's the names stored Last Name, First name ??

So do the numbers restart for each team ??

Is Henry say return a 5. Can a team have two players with the same name.

Please post an example of the names and output otherwise I can't help

VBA Noob

**Gearcutter** · 11-06-2006, 04:57 PM

Club Arsenal
1 J.Lehman
2 V.A.Diaby
3
4 C.Fabregas
5 K.Toure
6 P.Senderos
7 T.Rosicky
8 F.Ljungberg
9 J.Baptista
10 W.Gallas
11 R.Van Persie
12 Lauren
13 A.Hleb
14 T.Henry
15
16 M.Flamini
17 A.Song
18
19 Gilberto
20 J.Djourou
21 M.Poom
22 G.Clichy
23
24 M.Almunia
25 E.Adebayor
26
27 E.Eboue
28
29
30 J.Aliadiere
31 J.Hoyte
32 T.Walcott
33
34 M.Connolly
35
36
37
38
39
40

45 A.Stokes

Hi, That is the Arsenal 1st team squad with squad numbers, this is repeated for the rest of the teams in the Premiership. hope this of some help.
Howard