Alphabetical Order

[limo2088]

So if I paste some names, how can I have them automatically listed in alpabetical order? For Example: Column A has the names and Column E has them in alphabetical order which I started manuyally

Alphabetical.xlsx
	A	B	C	D	E
1	Names				Names In Alphabetical Order
2	Luis Enrique Torres				Andrew Lee Pickett
3	Shon Chad Byars				Anita Russell
4	James Edward Fleming
5	Andrew Lee Pickett
6	Anita Russell
7	Asia Dickey
8	Benjamin B Kratky
9	Cassidy Lynn Kaurich
10	Derrick Lamar Marshall
11	Dylan Daniel Stewart
12	Jason Daniel Grace
13	Jayda Marche Nix
14	Jessie Muheisien
15	Johnathan Terry McRae
16	Jonathon Andrew Honaker
17	LaShae Cherie Johnson
18	Lawrence Phillip Lambert
19	Lee Allen Donnelly
20	Marlesha Berry
21	Quinton Demoine Clemons
22	Ronald Michael Knight
23	Travis Allen Snider
24	Jeffrey Carl Othberg
25
Sheet1

 

[Candyman8019]

Go to the 'Data' menu and choose sort, by column A.

 

[Fluff]

Two formula options, one with a helper column & one without

+Fluff 1.xlsm
	A	B	C	D	E	F
1	Names					Names In Alphabetical Order
2	Luis Enrique Torres	18			Andrew Lee Pickett	Andrew Lee Pickett
3	Shon Chad Byars	22			Anita Russell	Anita Russell
4	James Edward Fleming	8			Asia Dickey	Asia Dickey
5	Andrew Lee Pickett	1			Benjamin B Kratky	Benjamin B Kratky
6	Anita Russell	2			Cassidy Lynn Kaurich	Cassidy Lynn Kaurich
7	Asia Dickey	3			Derrick Lamar Marshall	Derrick Lamar Marshall
8	Benjamin B Kratky	4			Dylan Daniel Stewart	Dylan Daniel Stewart
9	Cassidy Lynn Kaurich	5			James Edward Fleming	James Edward Fleming
10	Derrick Lamar Marshall	6			Jason Daniel Grace	Jason Daniel Grace
11	Dylan Daniel Stewart	7			Jayda Marche Nix	Jayda Marche Nix
12	Jason Daniel Grace	9			Jeffrey Carl Othberg	Jeffrey Carl Othberg
13	Jayda Marche Nix	10			Jessie Muheisien	Jessie Muheisien
14	Jessie Muheisien	12			Johnathan Terry McRae	Johnathan Terry McRae
15	Johnathan Terry McRae	13			Jonathon Andrew Honaker	Jonathon Andrew Honaker
16	Jonathon Andrew Honaker	14			LaShae Cherie Johnson	LaShae Cherie Johnson
17	LaShae Cherie Johnson	15			Lawrence Phillip Lambert	Lawrence Phillip Lambert
18	Lawrence Phillip Lambert	16			Lee Allen Donnelly	Lee Allen Donnelly
19	Lee Allen Donnelly	17			Luis Enrique Torres	Luis Enrique Torres
20	Marlesha Berry	19			Marlesha Berry	Marlesha Berry
21	Quinton Demoine Clemons	20			Quinton Demoine Clemons	Quinton Demoine Clemons
22	Ronald Michael Knight	21			Ronald Michael Knight	Ronald Michael Knight
23	Travis Allen Snider	23			Shon Chad Byars	Shon Chad Byars
24	Jeffrey Carl Othberg	11			Travis Allen Snider	Travis Allen Snider
25		0
26		0
27		0
28		0
29		0
30
Main

Cell Formulas
Range	Formula
E2:E29	E2	=IFNA(INDEX($A$2:$A$50,MATCH(ROWS(E$2:E2),$B$2:$B$50,0)),"")
F2:F29	F2	=IFERROR(INDEX($A$2:$A$50,AGGREGATE(15,6,(ROW($A$2:$A$50)-ROW($A$2)+1)/(COUNTIFS($A$2:$A$50,"<"&$A$2:$A$50)+1=ROWS(F$2:F2))/($A$2:$A$50<>""),1)),"")
B2:B29	B2	=COUNTIF($A$2:$A$50,"<="&A2)

 

[limo2088]

Two formula options, one with a helper column & one without

+Fluff 1.xlsm
	A	B	C	D	E	F
1	Names					Names In Alphabetical Order
2	Luis Enrique Torres	18			Andrew Lee Pickett	Andrew Lee Pickett
3	Shon Chad Byars	22			Anita Russell	Anita Russell
4	James Edward Fleming	8			Asia Dickey	Asia Dickey
5	Andrew Lee Pickett	1			Benjamin B Kratky	Benjamin B Kratky
6	Anita Russell	2			Cassidy Lynn Kaurich	Cassidy Lynn Kaurich
7	Asia Dickey	3			Derrick Lamar Marshall	Derrick Lamar Marshall
8	Benjamin B Kratky	4			Dylan Daniel Stewart	Dylan Daniel Stewart
9	Cassidy Lynn Kaurich	5			James Edward Fleming	James Edward Fleming
10	Derrick Lamar Marshall	6			Jason Daniel Grace	Jason Daniel Grace
11	Dylan Daniel Stewart	7			Jayda Marche Nix	Jayda Marche Nix
12	Jason Daniel Grace	9			Jeffrey Carl Othberg	Jeffrey Carl Othberg
13	Jayda Marche Nix	10			Jessie Muheisien	Jessie Muheisien
14	Jessie Muheisien	12			Johnathan Terry McRae	Johnathan Terry McRae
15	Johnathan Terry McRae	13			Jonathon Andrew Honaker	Jonathon Andrew Honaker
16	Jonathon Andrew Honaker	14			LaShae Cherie Johnson	LaShae Cherie Johnson
17	LaShae Cherie Johnson	15			Lawrence Phillip Lambert	Lawrence Phillip Lambert
18	Lawrence Phillip Lambert	16			Lee Allen Donnelly	Lee Allen Donnelly
19	Lee Allen Donnelly	17			Luis Enrique Torres	Luis Enrique Torres
20	Marlesha Berry	19			Marlesha Berry	Marlesha Berry
21	Quinton Demoine Clemons	20			Quinton Demoine Clemons	Quinton Demoine Clemons
22	Ronald Michael Knight	21			Ronald Michael Knight	Ronald Michael Knight
23	Travis Allen Snider	23			Shon Chad Byars	Shon Chad Byars
24	Jeffrey Carl Othberg	11			Travis Allen Snider	Travis Allen Snider
25		0
26		0
27		0
28		0
29		0
30
Main

Cell Formulas
Range	Formula
E2:E29	E2	=IFNA(INDEX($A$2:$A$50,MATCH(ROWS(E$2:E2),$B$2:$B$50,0)),"")
F2:F29	F2	=IFERROR(INDEX($A$2:$A$50,AGGREGATE(15,6,(ROW($A$2:$A$50)-ROW($A$2)+1)/(COUNTIFS($A$2:$A$50,"<"&$A$2:$A$50)+1=ROWS(F$2:F2))/($A$2:$A$50<>""),1)),"")
B2:B29	B2	=COUNTIF($A$2:$A$50,"<="&A2)

TY very much

 

[Fluff]

You're welcome & thanks for the feedback.