| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.......... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.......... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.......... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
