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
