Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.......... |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.......... |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.......... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can excel tell me what numbers in a given column sum to X? | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
how write excel formula numbers in column => &=< between 20-40 | New Users to Excel |