LinkBack URL
About LinkBacks
This macro should remove duplicates but it is not doing so.. Any ideas?
Please Login or Register to view this content.
This macro should remove duplicates but it is not doing so.. Any ideas?
Please Login or Register to view this content.
Post a small sample workbook with the raw data, tell us exactly what you're evaluating, and perhaps a sample "output" file you expect as a result of the small sample data set.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Here are the before and after files. id_customer 2007 in column A , second record is not removed with the current macro and should be.
The newest-original file is the macro file.
Hello christobalc,
For the macro to work, you must first sort the data in ascending order using column "D".
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Can you pl
ease post the correct code
see attachment, run macro "test"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks