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
