Hi Champs,
consider my example, i have many rows in a excel in which ID is unique.
But the ID has duplicated in many occurence.
I need a macro to highlight all the rows which is duplicated.
i have attached sample for the reference.sample.xlsx
Hi Champs,
consider my example, i have many rows in a excel in which ID is unique.
But the ID has duplicated in many occurence.
I need a macro to highlight all the rows which is duplicated.
i have attached sample for the reference.sample.xlsx
Hi Seeker,
Your sample was all duplicates??
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
mAY BE..
Please Login or Register to view this content.
Last edited by Debraj Roy; 11-27-2014 at 06:27 PM.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi Debraj,
Thanks for altering the code - it's just about what I had thought to do
Thanks for the macro.
your macro works with all the data which are duplicates.
eg
111010 AAA 100AB 5,000
111010 AAA 100AB 5,000
is any edit can be done in macro so that if any two cells are duplicates, the same has to be highlighted.
eg:
111010 AAA 111GG 5,000 - Duplicate
111010 AAA 100AB 5,000 - Duplicate
or
111010 BBB 111GG 1,000 - Duplicate
111010 AAA 111GG 1,000 - Duplicate
??. please help
Any two - do you mean the ID and one other or any one and any other??
This will handle the ID plus one other field:
Please Login or Register to view this content.
Last edited by xladept; 11-28-2014 at 06:20 PM.
yes.. But not ID and with any two other columns...
It's not nearly as elegant:
Please Login or Register to view this content.
Last edited by xladept; 12-01-2014 at 03:28 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks