Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
Data sortingPosted by Bob on December 23, 2001 4:42 PM
Is there any easy way to do a data sort on a file that has multiple "row" entries per item?
aaa a b c
4 5 6
er we as
bbb a c b
6 5 3
er qw as
ccc b c e
7 4 2
fg er rt
In this eample, I want to do an aphabetical sort on aaa, bbb, ccc and have the three rows of data for those variables to stay with the variables
Re: Data sortingPosted by Jacob on December 23, 2001 5:52 PM
Try Data|Sort then choose Left to Right
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.