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?