View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default SORT a column of Texts to follow another "EXACT" order

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