sorting a list

D

dee student

I have a column of faculty and need to sort it by rank in a particula
order. There are four ranks. How is this done? thanks for your hel
in advance
 
N

Nick Hodge

You could set up a custom sort list under Tools>Options>Custom Lists...
import or type your four derivatives in the order you want to sort them.

Once you have this set up, go to data>sort... and select the options...
button, now in the 'first key sort order' select your new list and click
ok,ok

This should sort you list how you want

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]


"dee student" <[email protected]>
wrote in message
news:[email protected]...
 
Top