How to remove a duplicate that doesn't have an address
I have a huge list with some duplicate "ID" numbers. With the rows that have this same "ID" number, one of the rows has an address the other(s) do not. Some rows that do not have duplicates might not have an address, so I don't want to just remove all rows without addresses. Is there a way to remove just the duplicates that do not have an address?
Welcome to the forum, cinci-hal.
I haven't used Excel 2003 for some time now - tell me, is conditional formatting available?
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Sorry, I have Excel 2010. I thought I put that in my profile, but I guess not.
No biggie
Use CF to highlight duplicate values; then filter by colour on that column (you'll only get duplicate values). Then filter your address column, showing only blanks. Delete the blanks, turn off the data filter, and you're done.
Thanks, That worked!
Glad to help. If your question has been answered to your satisfaction, can you please mark your thread "Solved".
You can use the Remove Duplicates option which is under Data Tools - Remove Duplicates and only check the Columns that have your ID numbers and address
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks