Hello, could someone please help me with the following:
In my Excel 2003 worksheet I need a macro to search column B for duplicate entries.
The data in column B is both numeric and string.
If there are any duplicate entries, then I need the duplicate rows to be deleted.
If any one could please help - it would be greatly appreciated.
Kind regards,
Chris
Last edited by longbow007; 10-15-2009 at 01:00 AM.
Hello Chris,
Post a few examples of the column "B" strings. Alphanumeric strings should not present a problem when identifying duplicates.
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!)
Here are two of my existing macros for this task, perhaps one will suit you when adjusted. The first one should be faster on large datasets:
Please Login or Register to view this content.
_________________
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!)
Hi Chris,
Use a helper column, say C. Assuming your data is in B1:B100 enter in C1
and copy this down column C.Please Login or Register to view this content.
Now filter on column C for values > 1 which represent those rows which have duplicate values lower down the list.
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanks JBeaucaire, Leith Ross and Richard Buttrey for all your excellent help and assistance - it is very much appreciated.
Kind regards,
Chris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks