Hi Sam solution provided by chilexcel is OK, but i want to go further in full automation using excel formulas.
Thanks Amit On Mon, Sep 26, 2011 at 11:49 AM, Sam Mathai Chacko <samde...@gmail.com>wrote: > Nicely done by Noorain. > > Shouldn't the solution provided by ChilExcel suffice? Pivot tables as it is > dynamic in nature, you just need to pass the source range. > > Regards, > > Sam Mathai Chacko (GL) > > > On Mon, Sep 26, 2011 at 11:40 AM, NOORAIN ANSARI <noorain.ans...@gmail.com > > wrote: > >> Dear Amit, >> >> Please see attached sheet.. >> >> and use >> * >> =INDEX($B$4:$B$150,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3) >> =Offset($B$4,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3,0)* >> >> -- >> Thanks & regards, >> Noorain Ansari >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >> >> On Mon, Sep 26, 2011 at 10:33 AM, Amit Gandhi <silkyro...@gmail.com>wrote: >> >>> Thanks alot Noorain >>> >>> It works fine. >>> >>> But I also want to automate Column E i.e. it automatically retrieve Co >>> Name as well. If you can help me here as well. >>> >>> Regards >>> >>> Amit >>> >>> >>> On Sat, Sep 24, 2011 at 8:54 PM, NOORAIN ANSARI < >>> noorain.ans...@gmail.com> wrote: >>> >>>> Dear Amit, >>>> Please see attached sheet, hope it will help to u. >>>> >>>> -- >>>> Thanks & regards, >>>> Noorain Ansari >>>> >>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >>>> >>>> On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi <silkyro...@gmail.com>wrote: >>>> >>>>> Hi Folks >>>>> >>>>> I am finding some problem in excel data. I have a excel data (attached >>>>> file) in vertical form. I want to convert it into Horizontal form using >>>>> Excel Formulas. >>>>> >>>>> Pls help me here. >>>>> >>>>> Regards >>>>> >>>>> Amit >>>>> >>>> >>>> >>>> >>>> >>>> >>> >>> >>> -- >>> 'Expecting the world to treat u fairly coz u r a good person is like >>> expecting the lion not to attack u coz u r a vegetarian. >>> Think about it.' >>> >>> Take care >>> >>> Amit >>> >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> > > > > -- > Sam Mathai Chacko > > -- > > ---------------------------------------------------------------------------------- > 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 > -- 'Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian. Think about it.' Take care Amit -- ---------------------------------------------------------------------------------- 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