Wow Rajan... that was very simple...
Regards, Manoj Kumar On Mon, Feb 7, 2011 at 10:27 PM, rajan verma <rajanverma1...@gmail.com>wrote: > 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.com>wrote: >> >>> 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.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 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 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
