Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Align data in 2 column in the same row if the user id's match
I have a spreadsheet with 1100 rows of data. I need to match the user id's in
column A with same user id in column D. Have their data all be on the same line and then move the misc. user id's to the bottom. Here is an example of the data as i have it. 21924811 4 21924811 4 21933349 12 21933349 12 21963483 12 21937422 7 21967689 8 21963483 9 21975516 9 21967689 8 this is what i need it to look like: 21924811 4 21924811 4 21933349 12 21933349 12 21963483 12 21963483 9 21967689 8 21967689 8 21975516 9 21975516 18 Currently I have a formula of A1-C1= 0's are equal, then i look at the non zeros and delete the rows i dont need so that they line up again. Very long and tedious process. Any ideas oh technical gods? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Align data in 2 column in the same row if the user id's match
Would sorting work?
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "simon" wrote in message ... I have a spreadsheet with 1100 rows of data. I need to match the user id's in column A with same user id in column D. Have their data all be on the same line and then move the misc. user id's to the bottom. Here is an example of the data as i have it. 21924811 4 21924811 4 21933349 12 21933349 12 21963483 12 21937422 7 21967689 8 21963483 9 21975516 9 21967689 8 this is what i need it to look like: 21924811 4 21924811 4 21933349 12 21933349 12 21963483 12 21963483 9 21967689 8 21967689 8 21975516 9 21975516 18 Currently I have a formula of A1-C1= 0's are equal, then i look at the non zeros and delete the rows i dont need so that they line up again. Very long and tedious process. Any ideas oh technical gods? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Align data in 2 column in the same row if the user id's match
No, I did sort and one report has almost 300 rows of additional user id's
that i dont need. "Bernard Liengme" wrote: Would sorting work? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "simon" wrote in message ... I have a spreadsheet with 1100 rows of data. I need to match the user id's in column A with same user id in column D. Have their data all be on the same line and then move the misc. user id's to the bottom. Here is an example of the data as i have it. 21924811 4 21924811 4 21933349 12 21933349 12 21963483 12 21937422 7 21967689 8 21963483 9 21975516 9 21967689 8 this is what i need it to look like: 21924811 4 21924811 4 21933349 12 21933349 12 21963483 12 21963483 9 21967689 8 21967689 8 21975516 9 21975516 18 Currently I have a formula of A1-C1= 0's are equal, then i look at the non zeros and delete the rows i dont need so that they line up again. Very long and tedious process. Any ideas oh technical gods? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort data in column B to align with data in column A? | New Users to Excel | |||
Align & Compare row with column | New Users to Excel | |||
User ID's | Excel Worksheet Functions | |||
column id's | Setting up and Configuration of Excel | |||
I need to randomize a column of alphanumeric employee ID's for a . | Excel Worksheet Functions |