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.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 > -- ---------------------------------------------------------------------------------- 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