thanks Noorain. 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 > -- '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
