Sorting by a custom list

M

mark1

In Excel:

I have a list of account numbers. Call it list A. I have
a list of the same account numbers, but in a different
order. Call it list B. How can I sort list B so that it
matches the order in list A? Custom list or something
like that? Thanks!!
 
B

Bob Phillips

Create a custom list in Tools>Options>Custom List and then select Options in
Data>Sort to use it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
D

DDM

Mark, Custom List it is. Select List A, then Tools > Options > Custom Lists
Import > OK. Then click in List B, and Data > Sort > Options. In First key
Click to expand...
sort options, select your custom list. Under Orientation, select Sort top to
bottom, then OK, and OK again.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
Top