Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread sunil bn
thnq so much.. On Tue, Mar 27, 2012 at 1:10 PM, Abhishek Jain wrote: > Right Click on cell...choose format cells > Custom > under the "Type:" use > this - > > *[>=1000]##\,##\,##\,##0;[>=10] ##\,##\,##0;##,##0 * > > > > On Tue, Mar 27, 2012 at 12:57 PM, sunil bn wrote: > >> Hi Abhishek

Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread Abhishek Jain
Right Click on cell...choose format cells > Custom > under the "Type:" use this - *[>=1000]##\,##\,##\,##0;[>=10] ##\,##\,##0;##,##0 * On Tue, Mar 27, 2012 at 12:57 PM, sunil bn wrote: > Hi Abhishek Jain , > > one more help. > > I need number should shown in Indian format like. > > E

Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread sunil bn
Hi Abhishek Jain , one more help. I need number should shown in Indian format like. Example 55,55,555 On Tue, Mar 27, 2012 at 12:43 PM, sunil bn wrote: > Hi Abhishek Jain , > > Sorry i got it... thnx very much..! > > Regards > Sunil B.N > > > On Tue, Mar 27, 2012 at 12:39 PM, Abhishek Jain w

Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread sunil bn
Hi Abhishek Jain , Sorry i got it... thnx very much..! Regards Sunil B.N On Tue, Mar 27, 2012 at 12:39 PM, Abhishek Jain wrote: > Did you change trying the syntax? > > > On Tue, Mar 27, 2012 at 12:32 PM, sunil bn wrote: > >> Hi Abhishek Jain , >> >> Its not working! >> >> >> On Tue,

Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread Abhishek Jain
Did you change trying the syntax? On Tue, Mar 27, 2012 at 12:32 PM, sunil bn wrote: > Hi Abhishek Jain , > > Its not working! > > > On Tue, Mar 27, 2012 at 12:23 PM, Abhishek Jain wrote: > >> Didn't try, but should work - >> >> http://answers.yahoo.com/question/index?qid=20071016005523A

Re: $$Excel-Macros$$ - Sunil B.N

2012-03-27 Thread sunil bn
Hi Abhishek Jain , Its not working! On Tue, Mar 27, 2012 at 12:23 PM, Abhishek Jain wrote: > Didn't try, but should work - > > http://answers.yahoo.com/question/index?qid=20071016005523AAlKbBa > > > On Tue, Mar 27, 2012 at 11:36 AM, sunil bn wrote: > >> Dear All, >> >> Please find the

Re: $$Excel-Macros$$ - Sunil B.N

2012-03-26 Thread Abhishek Jain
Didn't try, but should work - http://answers.yahoo.com/question/index?qid=20071016005523AAlKbBa On Tue, Mar 27, 2012 at 11:36 AM, sunil bn wrote: > Dear All, > > Please find the attached file. > > I Need the formula for Number to text in Indian Currency > > Attached file of your reference pls

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread NOORAIN ANSARI
Dear Sunil, Please use.. For 2007+ =AVERAGEIF(F1:F10,">0") For 2003 =SUMPRODUCT((F1:F10>0)*(F1:F10))/COUNTIF(F1:F10,"<>0") On Thu, Feb 9, 2012 at 4:49 PM, sunil bn wrote: > Hi Expert, > > > > Please find the attached file. > > > > 1. I need “average formula” which includes 0 value. > > --

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread sunil bn
Thank u maries Regards Sunil B.N ®Sent From Android Mobile© On 9 Feb 2012 17:02, "Maries" wrote: > Hi, > > Find the below formulas, > > =SUM(F1:F10)/COUNTIF(F1:F10,">0") > > =SUM(F1:F10) / (COUNT(F1:F10) - COUNTIF(F1:F10,0)) > > =SUMIF(F1:F10,">0")/COUNTIF(F1:F10,">0") > > =SUM(F1:F10)/(SUMPROD

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread Maries
Also Try, *=AVERAGEIF(F1:F10,">0") * On Thu, Feb 9, 2012 at 3:33 PM, Lakshman Prasad wrote: > Sorry, > > =AVERAGE(F2:F11) > > *From:* sunil bn > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, 9 February 2012 4:49 PM > *Subject:* $$Excel-Macr

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread Lakshman Prasad
Sorry,   =AVERAGE(F2:F11) From: sunil bn To: excel-macros@googlegroups.com Sent: Thursday, 9 February 2012 4:49 PM Subject: $$Excel-Macros$$ excel macros - Sunil B.N Hi Expert,   Please find the attached file.   1.  I need “average formula” which

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread Maries
Hi, Find the below formulas, =SUM(F1:F10)/COUNTIF(F1:F10,">0") =SUM(F1:F10) / (COUNT(F1:F10) - COUNTIF(F1:F10,0)) =SUMIF(F1:F10,">0")/COUNTIF(F1:F10,">0") =SUM(F1:F10)/(SUMPRODUCT((F1:F10<>0)*1)) Regards, MARIES. On Thu, Feb 9, 2012 at 3:19 PM, sunil bn wrote: > need “average formula” whi

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread Lakshman Prasad
Hello Mr. Sunil Use =AVERAGE(F2:F11,{1})     From: sunil bn To: excel-macros@googlegroups.com Sent: Thursday, 9 February 2012 4:49 PM Subject: $$Excel-Macros$$ excel macros - Sunil B.N Hi Expert,   Please find the attached file.   1.  I need

$$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread sunil bn
Hi Expert, Please find the attached file. 1. I need “average formula” which includes 0 value. -- *Regards* **Sunil B.N *** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Fo

Re: $$Excel-Macros$$ - Sunil B.N

2012-01-09 Thread NOORAIN ANSARI
Dear Sunil, missing attachment On Mon, Jan 9, 2012 at 4:33 PM, sunil bn wrote: > Hi Expert, > > I have attached file kindly help me to solve this. > > -- > > *Regards* > **Sunil B.N > ***9035858585 > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate

$$Excel-Macros$$ - Sunil B.N

2012-01-09 Thread sunil bn
Hi Expert, I have attached file kindly help me to solve this. -- *Regards* **Sunil B.N ***9035858585 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and