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

Reply via email to