Sorting by a custom list

[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!!

 

[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)

 

[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

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