Hi Satish It would be really helpful of you if you could show the same in an excel sheet.... required is that different duplicate sets should be identified by different colors so that we can diffentiate them and find how many value are duplicated...
Thanks a lot Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 11:23 AM, Sathish Jalendran <sath...@teamlease.com>wrote: > Hi, > > > > In that case we need to concatenate both the column and apply the same > function > > > > > > Regards > > Sathish Jalendran > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *vivek agrawal > *Sent:* 23 July 2009 AM 10:49 > > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: Duplicate colmuns > > > > hi sathish > > > > you have given a fantastic solution... > > > > but in this we cannot differentiate the duplicate sets.. > > > > > > Thanks and Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > > > On Thu, Jul 23, 2009 at 10:37 AM, Sathish Jalendran < > sath...@teamlease.com> wrote: > > Hi, > > > > Try the following > > > > > > > > > > Regards > > Sathish Jalendran > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Mahesh > *Sent:* 23 July 2009 AM 09:21 > *To:* excel-macros@googlegroups.com; dilipan...@sify.com > *Subject:* $$Excel-Macros$$ Duplicate colmuns > > > > Hi All, > > > > Need a solution here. > > > > attached is the sheet contain data in Column B &C. > > > > What i need is, if the data in both column are same then it will be > highlighted. > > > > Example:- > > > > 1 > > 12N0044 > > 076E5920 > > 2 > > 12N0648 > > 076E5920 > > 3 > > 12N0650 > > 076E4039 > > 4 > > 12N0650 > > 076E4039 > > > > > -- > With Love, > Mahesh Bisht > > > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive > > use of the addressee(s) and may contain proprietary, confidential or > privileged information. If you are not the intended > > recipient, you should not disseminate, distribute or copy this e-mail. > Please notify the sender immediately and destroy > > all copies of this message and any attachments contained in it. > > > > > > > > > > > > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive > use of the addressee(s) and may contain proprietary, confidential or > privileged information. If you are not the intended > recipient, you should not disseminate, distribute or copy this e-mail. > Please notify the sender immediately and destroy > all copies of this message and any attachments contained in it. > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
