Have you thought of copying column A and pasting over column B?


Gord Dibben MS Excel MVP

On Wed, 17 Sep 2008 08:57:01 -0700, 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