Hi here I am again.
After solving the delete duplicate rows question, I have a new question.
The duplicate rows have data in one column which I want to preserve.
I want to do that by getting all duplicate rows to copy their important data into a row which is the unique one (the unique one is the first duplicate in the column).
I've added an example.
some logical doubts
row no. 9
<= delete row as there is no data in column
row no. 14 or 15
<= do not alter
even thought there is no data in column G . why
is it because there is not duplicate of f or g values
clarify please
As for row 9, because column "b" already exist before, but it does not have any data, it is not relevant and can be deleted.
As for rows 14 and 15, indeed, because they do not appear before, they need to stay.
Last edited by Lithium; 07-08-2009 at 05:51 AM.
This is how I want to set up the macro:Does this look like a logical sequence? Has anyone reviewed my code to help me further?
- find the row of the first occurence
- check if it is not the same as the duplicate
- place the value of the duplicate in the row of the first occurence
This is the code that I want to change to include the above pieces.
Please Login or Register to view this content.
Last edited by Lithium; 07-08-2009 at 03:14 PM. Reason: spelling
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks