View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default SORT a column of Texts to follow another "EXACT" order

Maybe you could use a formula:

=A1
and drag down to B10.

But I don't understand what you're really doing.

F. Lawrence Kulchar wrote:

A B
KC BALT
DET TEN
NE WASH
PHI PIT
OAK STL
PIT KC
TEN NE
WASH OAK
BALT DET
STL PHI

There we have it: The same 10 names in column A appear in column B!

HOW CAN I REARRANGE COLUMN B TO EXACTLY DUPLICATE THE ORDER THAT COLUMN A IS
IN?

THANKS,

flkulchar


--

Dave Peterson