Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting in Excell based on 3 features

Status
Not open for further replies.

blazblaz

Technical User
Feb 3, 2002
71
CA
How can I sort in Excell based on 2 or 3 features? Example I want to sort base on column A,B,C, first on order o column A, then column B, then column C. The following example:
A B C
----------
10 A 1
10 A 2
10 A 3
10 B 1
10 B 2
20 A 1
20 A 2
20 A 3
20 B 1
30 A 1
30 A 2

Any suggestions?
 
Unless I am missing something, I believe Excel will let you this directly under Data, Sort. Choose Column A for the first "sort by" option, B for second "then by" option and C for third.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top