Re: $$Excel-Macros$$ Unique records
select all data and use data tab in excel 2007 or 10 then use remove duplicate uncheck all columns check only staff # basic. Regards, Aamir Shahzad On Mon, Feb 7, 2011 at 10:58 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Please find attached file where i intend to extract only unique records in column C (Basic) provided column B ( Staff No.) remains same. In other words, the objective is to extract Basic of same person for different periods. Sample data file attached. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Unique records
Thanks Divakar. Fantastic application of logic to get the output. Regards, C.G.Kumar On Tue, Feb 8, 2011 at 8:14 PM, Divaker Pandey divake...@gmail.com wrote: hi, Please find this one On Tue, Feb 8, 2011 at 10:10 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Thanks sir, It works.Could you please elaborate the steps in the formula, if possible. Regards, C.G.Kumar On Mon, Feb 7, 2011 at 3:56 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hi C.G, A little complex but hope this might help your needs... Regards, Manoj Kumar On Mon, Feb 7, 2011 at 2:42 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Not getting required result as i have to filter by two criteria ;1. staff no and 2. Basic. Same staff no may have different basic over period of time. After selecting unique records also, the output so generated is same is base records. Further, unique records does not works as two person may have same basic and therefore, filter criteria by unique records destroys the objective. Objective is to generate file having records as to when basic has changed for the concerned over the period of time. Thanks Regards, C.G.Kumar On Mon, Feb 7, 2011 at 1:12 PM, ashish koul koul.ash...@gmail.comwrote: use advance filter 1 select col a,b , c goto data- advance filter select unique records and click on copy to another loaction and select the destination cell On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar kumar.bemlmum...@gmail.com wrote: Please find attached file where i intend to extract only unique records in column C (Basic) provided column B ( Staff No.) remains same. In other words, the objective is to extract Basic of same person for different periods. Sample data file attached. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at
Re: $$Excel-Macros$$ Unique records
Not getting required result as i have to filter by two criteria ;1. staff no and 2. Basic. Same staff no may have different basic over period of time. After selecting unique records also, the output so generated is same is base records. Further, unique records does not works as two person may have same basic and therefore, filter criteria by unique records destroys the objective. Objective is to generate file having records as to when basic has changed for the concerned over the period of time. Thanks Regards, C.G.Kumar On Mon, Feb 7, 2011 at 1:12 PM, ashish koul koul.ash...@gmail.com wrote: use advance filter 1 select col a,b , c goto data- advance filter select unique records and click on copy to another loaction and select the destination cell On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Please find attached file where i intend to extract only unique records in column C (Basic) provided column B ( Staff No.) remains same. In other words, the objective is to extract Basic of same person for different periods. Sample data file attached. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Unique records
Sir, Thanks for the solution.However, unique records are not as required.This is due to the fact that you have considered all column e.g. Basic, Ser Wght, FPI, WRI,DPAY etc, whereas required unique records is for Basic records only for particular column. The solution suggested by you is very innovative and i would apply the same. I once again thanks for the courteous support. Regards, C.G.Kumar On Mon, Feb 7, 2011 at 10:27 PM, rajan verma rajanverma1...@gmail.comwrote: Hi Find attachment Rajan On Mon, Feb 7, 2011 at 2:26 AM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hi C.G, A little complex but hope this might help your needs... Regards, Manoj Kumar On Mon, Feb 7, 2011 at 2:42 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Not getting required result as i have to filter by two criteria ;1. staff no and 2. Basic. Same staff no may have different basic over period of time. After selecting unique records also, the output so generated is same is base records. Further, unique records does not works as two person may have same basic and therefore, filter criteria by unique records destroys the objective. Objective is to generate file having records as to when basic has changed for the concerned over the period of time. Thanks Regards, C.G.Kumar On Mon, Feb 7, 2011 at 1:12 PM, ashish koul koul.ash...@gmail.comwrote: use advance filter 1 select col a,b , c goto data- advance filter select unique records and click on copy to another loaction and select the destination cell On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Please find attached file where i intend to extract only unique records in column C (Basic) provided column B ( Staff No.) remains same. In other words, the objective is to extract Basic of same person for different periods. Sample data file attached. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our
Re: $$Excel-Macros$$ Unique records
Thanks sir, It works.Could you please elaborate the steps in the formula, if possible. Regards, C.G.Kumar On Mon, Feb 7, 2011 at 3:56 PM, Manoj kumar manoj.vishwakarma...@gmail.comwrote: Hi C.G, A little complex but hope this might help your needs... Regards, Manoj Kumar On Mon, Feb 7, 2011 at 2:42 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Not getting required result as i have to filter by two criteria ;1. staff no and 2. Basic. Same staff no may have different basic over period of time. After selecting unique records also, the output so generated is same is base records. Further, unique records does not works as two person may have same basic and therefore, filter criteria by unique records destroys the objective. Objective is to generate file having records as to when basic has changed for the concerned over the period of time. Thanks Regards, C.G.Kumar On Mon, Feb 7, 2011 at 1:12 PM, ashish koul koul.ash...@gmail.comwrote: use advance filter 1 select col a,b , c goto data- advance filter select unique records and click on copy to another loaction and select the destination cell On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Please find attached file where i intend to extract only unique records in column C (Basic) provided column B ( Staff No.) remains same. In other words, the objective is to extract Basic of same person for different periods. Sample data file attached. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Unique records
Wow Rajan... that was very simple... Regards, Manoj Kumar On Mon, Feb 7, 2011 at 10:27 PM, rajan verma rajanverma1...@gmail.comwrote: Hi Find attachment Rajan On Mon, Feb 7, 2011 at 2:26 AM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hi C.G, A little complex but hope this might help your needs... Regards, Manoj Kumar On Mon, Feb 7, 2011 at 2:42 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Not getting required result as i have to filter by two criteria ;1. staff no and 2. Basic. Same staff no may have different basic over period of time. After selecting unique records also, the output so generated is same is base records. Further, unique records does not works as two person may have same basic and therefore, filter criteria by unique records destroys the objective. Objective is to generate file having records as to when basic has changed for the concerned over the period of time. Thanks Regards, C.G.Kumar On Mon, Feb 7, 2011 at 1:12 PM, ashish koul koul.ash...@gmail.comwrote: use advance filter 1 select col a,b , c goto data- advance filter select unique records and click on copy to another loaction and select the destination cell On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Please find attached file where i intend to extract only unique records in column C (Basic) provided column B ( Staff No.) remains same. In other words, the objective is to extract Basic of same person for different periods. Sample data file attached. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just
Re: $$Excel-Macros$$ Unique records
use advance filter 1 select col a,b , c goto data- advance filter select unique records and click on copy to another loaction and select the destination cell On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Please find attached file where i intend to extract only unique records in column C (Basic) provided column B ( Staff No.) remains same. In other words, the objective is to extract Basic of same person for different periods. Sample data file attached. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Unique records
Hi Ashish Thank you ... You made it very simple. I was finding it difficult to loop. Thanks Omar for the input. Thanks and Regards Umesh Dev On Sat, Jan 15, 2011 at 9:53 PM, ashish koul koul.ash...@gmail.com wrote: check the attachement see if it helps On Sat, Jan 15, 2011 at 7:14 PM, Umesh Dev umesh.d...@gmail.com wrote: Hi All, Can anyone help me with the code in *VBA *to find unique values and pasting it separately in Excel. Regards Umesh Dev -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Unique records
Range(a:a).RemoveDuplicates 1, xlNo From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, January 15, 2011 6:24 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Unique records check the attachement see if it helps On Sat, Jan 15, 2011 at 7:14 PM, Umesh Dev umesh.d...@gmail.com wrote: Hi All, Can anyone help me with the code in VBA to find unique values and pasting it separately in Excel. Regards Umesh Dev -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.com http://akoul.wordpress.com/ akoul.wordpress.com My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel