MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sorting


Posted by ross on November 08, 2001 5:56 AM

alrighty,

can i sort my rows of data based on one column? ie will all the row move or just the column i sort on, i want the whole rec to move......
having done that can i then sorted the "sorted" data based on another column eg
a 3
d 2
a 2
c 4
b 1

then first get
a 3
a 2
b 1
c 4
d 2

and finally:
a 2
a 3
b 1
c 4
d 2


plsssssssssss help its driving me mad!!!!!


Posted by Mark W. on November 08, 2001 6:17 AM

Select the entire row before you choose the
Data | Sort... menu command. For more info
on sorting see the Excel Help Index topic for
"sorting, overview".