Re: $$Excel-Macros$$ MOST REPEATED NO

2012-08-17 Thread Amit Gandhi
> > * * > > *From:* Rajan_Verma [mailto:rajanverma1...@gmail.com] > *Sent:* 17 August 2012 10:19 > *To:* 'excel-macros@googlegroups.com' > *Subject:* RE: $$Excel-Macros$$ MOST REPEATED NO > > ** ** > > * * > > *If your list is Name is rng

Re: $$Excel-Macros$$ MOST REPEATED NO

2012-08-17 Thread Amit Gandhi
-- > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* Amit Gandhi > *To:* exce

RE: $$Excel-Macros$$ MOST REPEATED NO

2012-08-17 Thread Rajan_Verma
Another solution is =Mode(rng) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 17 August 2012 10:19 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ MOST REPEATED NO If your list is N

RE: $$Excel-Macros$$ MOST REPEATED NO

2012-08-17 Thread Rajan_Verma
groups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 17 August 2012 9:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ MOST REPEATED NO Or, a macro to round b.. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From:

Re: $$Excel-Macros$$ MOST REPEATED NO

2012-08-17 Thread dguillett1
Or, a macro to round b.. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Friday, August 17, 2012 10:43 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ MOST REPEATED NO Or directly by rounding in the formula itself

Re: $$Excel-Macros$$ MOST REPEATED NO

2012-08-17 Thread Sam Mathai Chacko
Gandhi > *Sent:* Friday, August 17, 2012 1:30 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ MOST REPEATED NO > > Hi Experts > > If there is any formula which can calculate MOST REPEATED NO from a list? > Sample file attached. > > Pls help me

Re: $$Excel-Macros$$ MOST REPEATED NO

2012-08-17 Thread dguillett1
Gandhi Sent: Friday, August 17, 2012 1:30 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MOST REPEATED NO Hi Experts If there is any formula which can calculate MOST REPEATED NO from a list? Sample file attached. Pls help me here. Regards Amit -- Join official facebook

Re: $$Excel-Macros$$ MOST REPEATED NO

2012-08-17 Thread Paul Schreiner
can, As long as ever you can.” - John Wesley - From: Amit Gandhi To: excel-macros@googlegroups.com Sent: Fri, August 17, 2012 2:30:41 AM Subject: $$Excel-Macros$$ MOST REPEATED NO Hi Experts If there is any formula which can calculat

Re: $$Excel-Macros$$ MOST REPEATED NO

2012-08-17 Thread Amit Gandhi
Hi Kuldeep Its not working. Pls show example in sample file. Regards Amit On Fri, Aug 17, 2012 at 12:08 PM, Kuldeep Singh wrote: > > You can try this. > > =COUNTIF(B3:B21,B3)>1 > > Regards, > Kuldeep Singh > Phone.: +91-120-4763789, Extn.: 789 > naukrikuld...@gmail.com || www.naukri.com > *Pl

Re: $$Excel-Macros$$ MOST REPEATED NO

2012-08-16 Thread Kuldeep Singh
You can try this. =COUNTIF(B3:B21,B3)>1 Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Fri, Aug 17, 2012 at 12:00 PM, Amit Gandhi wrote: > Hi

$$Excel-Macros$$ MOST REPEATED NO

2012-08-16 Thread Amit Gandhi
Hi Experts If there is any formula which can calculate MOST REPEATED NO from a list? Sample file attached. Pls help me here. Regards Amit -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use con