Click on column a and do an a-z sort using 'continue with current selection'
and then do the same for column b

--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"sasidharan" wrote:

How to match the two column of numbers in Excel ?

eg.

A B
1 1 2
2 0 0
3 2 1

Now i need, its should be like this...........

A B
1 0 0
2 1 1
3 2 2

How can i change like this..........