How do I sort data in column B to align with data in column A?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jephri1 - 18 Apr 2008 04:14 GMT

Im fairly green to Excel but what I am after is I want to be able to sort a
range of codes in Column B to basically move and realign to the same row as
the data that is in Colmn A eg
Start
Column A Column B
R F
G B
B H
H R
F G
Finish
Column A Column B
R R
G G
B B
H H
F F

Reply to this Message

Teethless mama - 18 Apr 2008 05:05 GMT

Piece a cake.
Delete columm B, then copy column A and paste into Column B

> Im fairly green to Excel but what I am after is I want to be able to sort a
> range of codes in Column B to basically move and realign to the same row as
[quoted text clipped - 13 lines]
> H H
> F F

Reply to this Message