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
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
Can you post an example of ranges and gaps and expected result.
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
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
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
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
Surname then ??
What is your expected result.
No gaps ??
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks