Hi I hope the enclsd sheet will help you.
Regards Umesh Dev On Sun, Jan 30, 2011 at 12:40 PM, Ms-Exl-Learner . <ms.exl.lear...@gmail.com > wrote: > Hi Vikalp, > > Please refer the attached excel for solution. > > I have automated everything in formula and you need not to do any manual > input in Solution Sheet. Just you need to Copy and paste the formula to the > rest of the rows based on your requirement. > > In Data Sheet you have to extend the formula used as Helper Column1 and > Helper Column2 (Column F & Column G) based on the Unique ID No data of > Column B. > > I hope its Clear to you! > > ----------------------- > Ms.Exl.Learner > ----------------------- > > On Fri, Jan 28, 2011 at 1:31 PM, vikalp <dostvik...@gmail.com> wrote: > >> hellow everybody, >> kindly help me with the problem i am facing i want to remove >> repititive record from folloeing data and get useful data for the >> perpose of mailmerge example is given bellow >> example data I have >> a b c d >> 1 x 20 35 >> 1 x 25 35 >> 1 x 26 145 >> 1 x 35 2568 >> 2 y 24 85 >> 2 y 25 7431 >> 2 y 620 556 >> 3 z 25 451 >> 3 z 25 451 >> >> data format I require >> >> a d c1 d1 c2 d2 c3 d3 c4 d4 >> 1 x 20 35 25 35 26 145 35 2568 >> 2 y 24 85 25 7431 620 556 >> 3 z 25 451 25 451 >> >> knly help me please >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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
Solution-1.xlsm
Description: Binary data