Hi,
In last code given put Y agaist promoter & u will get data for only
promoters..
Rgds//Vabs
On Friday, September 21, 2012 10:10:50 AM UTC+5:30, amar takale wrote:
>
> Hi Vabz
> I create file with index formula now I want to In Output(2) sheet all
> promoter in one shot for all Qtr.I used Da
Hi VabZ
Currently I am not create sheet But In my mind that type of idea generated
So I will try it. If I will create this sample file I will send it Then you
Guide me further activity
Thanks very much
On Thu, Sep 20, 2012 at 12:54 PM, Vabz wrote:
> Hi
>
> can you share your sample result data
Hi
can you share your sample result data in given example in separate sheet.
Rgds//Vabs
On Thursday, September 20, 2012 12:19:01 PM UTC+5:30, amar takale wrote:
>
> Dear Vabs
> I already use auto filter to get data.With auto filter I will get only One
> Year Data But I want all Data in one sho
Dear Vabs
I already use auto filter to get data.With auto filter I will get only One
Year Data But I want all Data in one shot
On Thu, Sep 20, 2012 at 12:06 PM, Vabz wrote:
> Hi
>
> Why dont you use filer to get data.
>
> Rgds//Vabs
>
>
> On Thursday, September 20, 2012 11:44:56 AM UTC+5:30, ama
Hi
Why dont you use filer to get data.
Rgds//Vabs
On Thursday, September 20, 2012 11:44:56 AM UTC+5:30, amar takale wrote:
>
> Hi All Champs,
> Anybody help me regarding tup formula solution.
> Q: I want to see Sector wise promotor,FII & so on (From Dec04-Jun05) in
> one shot.When I click sect
Dear NOORAIN,
Thanks for reply,I used this formula but not work it show #VALUE! .I think
formula is correct but how to use in it offset.why formula not work?
On Wed, Aug 22, 2012 at 10:00 PM, NOORAIN ANSARI
wrote:
> Dear Amar,
>
> pls Try it..
>
>
> =SUMPRODUCT((List=OFFSET($A$2,$AI$3,0))*($B$3:$
Dear Amar,
pls Try it..
=SUMPRODUCT((List=OFFSET($A$2,$AI$3,0))*($B$3:$B$50=AK$7)*($C$2:$N$2=$AJ8)*($C$3:$N$50))
On Wed, Aug 22, 2012 at 2:54 PM, amar takale wrote:
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members alre