Re: $$Excel-Macros$$ Formula: Count

2013-09-20 Thread Chandra Shekar
*Subject:* Re: $$Excel-Macros$$ Formula: Count ** ** Hello, Thank a lot its working fine. Regards, Chandra On Thu, Sep 19, 2013 at 12:08 PM, Ravinder ravinderexcelgr...@gmail.com wrote: PFA OR USE =SUM((C2=IF(FREQUENCY(MATCH($A$2

RE: $$Excel-Macros$$ Formula: Count

2013-09-19 Thread Ravinder
18, 2013 4:13 PM To: excel-macros@googlegroups.com Cc: ashish koul Subject: Re: $$Excel-Macros$$ Formula: Count Hello, Thanks for your replies. Formulas are working for one set of data but its not working for other criterias I have attached new excel could you please check it. Ashish - I

Re: $$Excel-Macros$$ Formula: Count

2013-09-19 Thread Chandra Shekar
) WITH CSE ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Wednesday, September 18, 2013 4:13 PM *To:* excel-macros@googlegroups.com *Cc:* ashish koul *Subject:* Re: $$Excel-Macros$$ Formula: Count ** ** Hello

RE: $$Excel-Macros$$ Formula: Count

2013-09-19 Thread Excel Beginner
Of Chandra Shekar Sent: Thursday, September 19, 2013 1:24 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula: Count Hello, Thank a lot its working fine. Regards, Chandra On Thu, Sep 19, 2013 at 12:08 PM, Ravinder ravinderexcelgr...@gmail.com wrote: PFA OR USE =SUM

RE: $$Excel-Macros$$ Formula: Count

2013-09-18 Thread Ravinder
=SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,), ),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),)),1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Tuesday, September 17, 2013 6:00 PM To:

Re: $$Excel-Macros$$ Formula: Count

2013-09-18 Thread Chandra Shekar
Hello, Thanks for your replies. Formulas are working for one set of data but its not working for other criterias I have attached new excel could you please check it. *Ashish - *I am trying to get count of unique records based on multi conditions where I know what is Condition1 but I will be not

Re: $$Excel-Macros$$ Formula: Count

2013-09-17 Thread ashish koul
xy1? what does this mean do you want to count RS with point 1 and so on Regards Ashish On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, I need formula to count no of points based on condtion please find attached file. Thanks, Chandra --

Re: $$Excel-Macros$$ Formula: Count

2013-09-17 Thread Anoop K Sharma
Check the Attachment... On Tue, Sep 17, 2013 at 8:45 PM, ashish koul koul.ash...@gmail.com wrote: xy1? what does this mean do you want to count RS with point 1 and so on Regards Ashish On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, I

RE: $$Excel-Macros$$ Formula: Count

2013-09-17 Thread Ravi Kumar
Subject: Re: $$Excel-Macros$$ Formula: Count Check the Attachment... On Tue, Sep 17, 2013 at 8:45 PM, ashish koul koul.ash...@gmail.com mailto:koul.ash...@gmail.com wrote: xy1? what does this mean do you want to count RS with point 1 and so on Regards Ashish On Tue, Sep 17, 2013 at 5