com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Thursday, May 19, 2011 7:25 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct
>
>
>
> Hi,
>
>
>
> Thanks for the repl
s.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct
Hi Asish,
Please reply to the mail. :)
I have attached both the files for your information.
Regards,
Chandra Shekar B
On Tue, May 17, 2011 at 7:34 PM, Chandra Shekar
mailto:chandrasheka
ge
>
> IP Phone - 512320 | Mobile - 90290 32123
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Wednesday, May 18, 2011 7:51 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$E
Hi Ashish,
Please find attached file.
Thanks,
Chanra Shekar B
On Tue, May 17, 2011 at 6:09 PM, ashish koul wrote:
> i have made changes in the data may be because of that can you attach the
> sample file back
>
>
> On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar <
> chandrashekarb@gmail.
i have made changes in the data may be because of that can you attach the
sample file back
On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi Asish,
>
> Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN
> & AVG for first record s
Hi Asish,
Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN
& AVG for first record should be 100, 50 & avergage should be 87.5.
Can we use sumproduct for all the formulas instead of array formulas. Thanks
in advanc.
Regards,
Chandra Shekar B
On Mon, May 16, 2011 at 9:
try this
On Mon, May 16, 2011 at 12:12 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> I want Min Max and Average by using Sumproduct. My problem is I want a
> formula which should be based on Date and Title as shown on Column D, E & F
> and based on Column C I need Average, M