how to match the two column with numbers in excel?
 

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..........

how to match the two column with numbers in excel?
 

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..........

how to match the two column with numbers in excel?
 

sasidharan,

To add to what John stated, if it is something you will be doing a lot of,
then you can record a macro that will do it all for you.

Les

"john" wrote:

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..........