Hello:
I need to remove the identical records from this list since the identical records indicate clients all ready contacted. i.e rows 6,7,8 & 9 are identical records and need to be removed from the list. The criiteria should also include Unit # or # since if its an apartment, the addresses for the apartment will all be the same; only the apt # or unit # will differentiate it.
Thank you in advance for your help.
Kindest regards,
Vic
list_04-19-2014.jpg
Hi Vic,
There is a YouTube that shows exactly this. See http://www.youtube.com/watch?v=pM6Q7cPph1c
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hello Marvin,
That doesn't work. It only removes the duplicate. The other matching record will still be in the list. I need to remove all the matching records. ty
Hi Vic,
You really need to attach a sample Excel file so we can see what you have. My guess is a "Helper Column" that counted the duplicates might help. Then you could sort by that column and simply delete the rows that have a number greater than one.
Attach a sample file and we can show you how.
Hello Marvin:
i did attached a sample file. Click the link below my name. ty
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Having said that, maybe this approach will help?
Use a helper column with a countif() function in it. Apply filters to show only values in the helper > 1 - delete what shows
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here's part of the file. Again any matching records need to be removed. I appreciate your help ty
https://drive.google.com/file/d/0B6r...it?usp=sharing
Sorry, please upload your file to the forum, not all members are able - or willing - to download from file-hosting sites
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Hi Vic,
See what my suggestion is using the attached file.
Thanks for the uploading info. Here's the file. ty!
Marvin, I think your Countif formula will work. That might be tricky with the Unit # entries. ty
la90292,
Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.
In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.
Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.
Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
If I have 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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks