G Guest Jun 28, 2004 #1 I have a long list like this it is sorted in the first column A to Z but I want to sort by second column 1 , 2, 3, 4 etc. Help please
I have a long list like this it is sorted in the first column A to Z but I want to sort by second column 1 , 2, 3, 4 etc. Help please
G Guest Jun 29, 2004 #2 sorry forgot the list ANTHONY Merv, Ruth, Sarah, Jaremy 113 A.P.S. SERVICES 516 APOLLO DRILLING 63 APOLLO GOLD CORP 605 ARDIANNA ENTERPRISE 160 ARLA INVESTMENT 38 ARMSTRONG, Pat 10 ARPIN, Isabelle 495 ARPIN, Laurent, Carol, Valerie 458 ARSENAULT CLAIRE 22 ARSENAULT, Jean, Carol, Serge, Zoé 352
sorry forgot the list ANTHONY Merv, Ruth, Sarah, Jaremy 113 A.P.S. SERVICES 516 APOLLO DRILLING 63 APOLLO GOLD CORP 605 ARDIANNA ENTERPRISE 160 ARLA INVESTMENT 38 ARMSTRONG, Pat 10 ARPIN, Isabelle 495 ARPIN, Laurent, Carol, Valerie 458 ARSENAULT CLAIRE 22 ARSENAULT, Jean, Carol, Serge, Zoé 352
D Dave Peterson Jun 29, 2004 #3 Select your whole range first (all the columns that are part of the range). Data|Sort Choose the second column as your primary sort key. (make sure you check that header row according to your data).
Select your whole range first (all the columns that are part of the range). Data|Sort Choose the second column as your primary sort key. (make sure you check that header row according to your data).
