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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I sort data in column B to align with data in column A? (https://www.excelbanter.com/new-users-excel/184189-how-do-i-sort-data-column-b-align-data-column.html)

Jephri1

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

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

Teethless mama

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

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

"Jephri1" wrote:

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

All times are GMT +1. The time now is 10:53 AM.