Parth48
asked on
how can i remove duplicate values from the excel sheet ??
i want to know that how can i remove duplicate values from the excel sheet using excel macros??
here i attach the excel sheet as well as attached snapshot ...
please refer the attached document ....
here i attach the excel sheet as well as attached snapshot ...
please refer the attached document ....
ASKER
ASKER
in attached snapshot i want to remove duplicate values from marked area (using red line) ...
using macros (including for loop)
using macros (including for loop)
what do you define as a dupe?
- any individual cell that is replicated
- matching an entire row
- matching an entire column (D and F)
My addin will handle the first two, not the last
And do you specifically want code that you can see (the addin is code), and if so why - for you to modify?
Cheers
Dave
- any individual cell that is replicated
- matching an entire row
- matching an entire column (D and F)
My addin will handle the first two, not the last
And do you specifically want code that you can see (the addin is code), and if so why - for you to modify?
Cheers
Dave
ASKER
matching an entire column (A,B,C,D,E and F) (not rows)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi @brettdj: Thanks very much ...
But my The Duplicate Master" at this EE article link, https://www.experts-exchange.com/A_2123.html
will handle your requests with functionality for the entireworbook, one, several or all columns in a row etc
Cheers
Dave