Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare Rows and delete duplicate records
HI,
I am very new to excel and trying to find a solution to filter my data. My data lookes like the following A B C D E F ............... joe 12 14 16 90 80 joe 12 15 18 90 80 john 13 19 20 90 70 Sara 13 20 21 22 23 Sara 13 20 24 25 23 I want to combine the unique records of each user from all the rows into one row so that it should look like below A B C D E F G H I J joe 12 14 16 90 80 15 18 john 13 19 20 90 70 Sara 13 20 21 22 23 24 25 I am sure most of you would know how to accomplsih it. Any quick help will be greatly appreciated. Dizzlews -- Looking for some help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare Rows and delete duplicate records
Hi Dizzlews,
How do you want to combine the data of each user if there are different entries in the same column. You want to sum them or find the max or what? "Dizzlews" wrote: HI, I am very new to excel and trying to find a solution to filter my data. My data lookes like the following A B C D E F ............... joe 12 14 16 90 80 joe 12 15 18 90 80 john 13 19 20 90 70 Sara 13 20 21 22 23 Sara 13 20 24 25 23 I want to combine the unique records of each user from all the rows into one row so that it should look like below A B C D E F G H I J joe 12 14 16 90 80 15 18 john 13 19 20 90 70 Sara 13 20 21 22 23 24 25 I am sure most of you would know how to accomplsih it. Any quick help will be greatly appreciated. Dizzlews -- Looking for some help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare Rows and delete duplicate records
First of all, my apologies for my late response to your post. I got the email
from Microsoft but I was not able to go on to post the when I clicked on the Link. I finally found my own post after two days. to answer your question, It does not matter where the entries are in the column, they will not follow any sequence. So i am assuming if you have happen to have the Macro code, each cell value needs to loop through the entire row. Taking the example again for my data for Joe. A B C D E F ............... R1 joe 12 14 16 90 80 R2 joe 12 15 18 90 80 I believe this is how it should work. 1) Compare A2 with A1 If Not Equal then Do nothing Else if equals then B1, should be compared against all the values in row 1 for Joe, If found a match then Do Nothing Else if did not Found the Match then Add to the row1 for joe, the sequence does not matter....... Similarly B2, B3.........untill B100. Once Row2 is completely comapred and added to row1, then it should deleted. Thanks A B C D E F ............... joe 12 14 16 90 80 joe 12 15 18 90 80 john 13 19 20 90 70 Sara 13 20 21 22 23 Sara 13 20 24 25 23 I want to combine the unique records of each user from all the rows into one row so that it should look like below A B C D E F G H I J joe 12 14 16 90 80 15 18 john 13 19 20 90 70 Sara 13 20 21 22 23 24 25 I am sure most of you would know how to accomplsih it. Any quick help will be greatly appreciated. Dizzlews -- Looking for some help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare Rows and delete duplicate records
I am sorry I meant B2 in my example.... I have corrected it below again
-- Looking for some help "Dizzlews" wrote: First of all, my apologies for my late response to your post. I got the email from Microsoft but I was not able to go on to post the when I clicked on the Link. I finally found my own post after two days. to answer your question, It does not matter where the entries are in the column, they will not follow any sequence. So i am assuming if you have happen to have the Macro code, each cell value needs to loop through the entire row. Taking the example again for my data for Joe. A B C D E F ............... R1 joe 12 14 16 90 80 R2 joe 12 15 18 90 80 I believe this is how it should work. 1) Compare A2 with A1 If Not Equal then Do nothing Else if equals then B2, should be compared against all the values in row 1 for Joe, If found a match then Do Nothing Else if did not Found the Match then Add to the row1 for joe, the sequence does not matter....... Similarly B3, B4.........untill B100. Once Row2 is completely comapred and added to row1, then it should deleted. Thanks A B C D E F ............... joe 12 14 16 90 80 joe 12 15 18 90 80 john 13 19 20 90 70 Sara 13 20 21 22 23 Sara 13 20 24 25 23 I want to combine the unique records of each user from all the rows into one row so that it should look like below A B C D E F G H I J joe 12 14 16 90 80 15 18 john 13 19 20 90 70 Sara 13 20 21 22 23 24 25 I am sure most of you would know how to accomplsih it. Any quick help will be greatly appreciated. Dizzlews -- Looking for some help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare and delete duplicate records | Excel Worksheet Functions | |||
Delete Duplicate records | Excel Worksheet Functions | |||
how to delete duplicate records in a row | Setting up and Configuration of Excel | |||
How do I delete duplicate records from an entire Excel workbook? | Excel Discussion (Misc queries) | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |