Re: $$Excel-Macros$$ Count in cell formula

2013-01-18 Thread The Viper
Dear Excel Learner, *"You can also try"* Google stats will show you in active posters list and you will get more counts. On Fri, Jan 18, 2013 at 4:39 PM, Ms-Exl-Learner wrote: > Hm... No one is understanding what I am trying to say... > > It's not only about this post, I am also talking about

Re: $$Excel-Macros$$ Count in cell formula

2013-01-18 Thread Ms-Exl-Learner
@Gawli Anil, Hm... No one is understanding what I am trying to say... It's not only about this post, I am also talking about the posts in which I am not at all involved. if you see in every post I am seeing everyone knowingly doing the copy paste of the same solution which is already offered

Re: $$Excel-Macros$$ Count in cell formula

2013-01-18 Thread अनिल नारायण गवली
Dear Ms-Exl-Learner, Hey Dear, Keep helping others that's good but don't tally with others... You has done it ...that's good we appreciate ur talent:) Warm Regards, Gawli Anil On Fri, Jan 18, 2013 at 4:03 PM, Ms-Exl-Learner wrote: > @ Gawli Anil, > > I am not seeing anyone spent

Re: $$Excel-Macros$$ Count in cell formula

2013-01-18 Thread Ms-Exl-Learner
@ Gawli Anil, I am not seeing anyone spent time in giving solution for this, Just seeing copy paste, *Including your post*. On 18-01-2013 10:32 AM, ?? wrote: Hey Our User , Yaar don't get personal afterall we have to help others. Warm Regardsm Gawli Anil On Fri, Jan 18

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread amar takale
Dear All My friend, Thanks everybody to solved my problem & spent time for my solution. With the help of expertise, I am very Glad Regards Amar On Fri, Jan 18, 2013 at 10:32 AM, अनिल नारायण गवली wrote: > Hey Our User , > > Yaar don't get personal afterall we have to help others. > >

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread अनिल नारायण गवली
Hey Our User , Yaar don't get personal afterall we have to help others. Warm Regardsm Gawli Anil On Fri, Jan 18, 2013 at 2:46 AM, Excel_Lover wrote: > ha ha!!! > > > > On Thu, Jan 17, 2013 at 2:22 PM, Ms-Exl-Learner > wrote: > >> @ Noorain Ansari, >> >> Could you ple

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread Excel_Lover
ha ha!!! On Thu, Jan 17, 2013 at 2:22 PM, Ms-Exl-Learner wrote: > @ Noorain Ansari, > > Could you please explain what is the use of *Sumproduct* in your below > formula? > > *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1)* > > Why not it should be *LEN(C5)-LEN(SUBSTITUTE(C5,

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread venus
venus On Jan 17, 2013 3:41 PM, "amar takale" wrote: > Dear champs > Pl suggest simple count formula in cell > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > He

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread NOORAIN ANSARI
Okay i gotbut i have not taken 30 minutes for this solution. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread Ms-Exl-Learner
@ Noorain Ansari, Could you please explain what is the use of /*Sumproduct*/ in your below formula? /*=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1)*/ Why not it should be /*LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1*/? Since both will result the same answer. *My Suggestion Posted HALF AN HOU

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread NOORAIN ANSARI
If cell is non-blank you can use. it.. On Thu, Jan 17, 2013 at 4:19 PM, NOORAIN ANSARI wrote: > Dear Amar, > > You can also try... > > *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1) > * > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread NOORAIN ANSARI
Dear Amar, You can also try... *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1) * -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread अनिल नारायण गवली
psl find attached herewith Warm Regards, Gawli Anil On Thu, Jan 17, 2013 at 3:48 PM, Ms-Exl-Learner wrote: > =IF(LEN(TRIM(C5)),LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1,"") > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official Facebook

Re: $$Excel-Macros$$ Count in cell formula

2013-01-17 Thread Ms-Exl-Learner
* In D5 cell =IF(LEN(TRIM(C5)),LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1,"") Drag it down...* On 17-01-2013 3:40 PM, amar takale wrote: Dear champs Pl suggest simple count formula in cell -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use co