I have one excel 07 document which was 2 documents originally. I've merged it so it's one document. Now I need to get rid of the duplicates but where there is a duplicate I need to change the code in one column so I know it was on both lists originally - any ideas?
Do you still have the 2 original documents or is there a way for you to identify which row belongs to which of the 2 files?
You need a small code that will combine the data again (if possible) and add a column that will denote the file number(whether 1 or 2). The code will then go thru each line and if it finds duplicates, update the code in the column required.
Will this work? If yes, attach the sample files and i can help you out.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi annes and welcome to the forum,
I don't think you need VBA for this. A helper column with this at the top and then pull it down might work.
See the attached.=COUNTIF(A$1:A2,A2)
All helper column numbers of 2 are duplicates of above. You could sort by the helper and then delete the dups if that is what you want.
One test is worth a thousand opinions.
Click the * below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks