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
Thanks Mr. Paul For such a beautiful & accurate reply. On Fri, Aug 17, 2012 at 6:50 PM, Paul Schreiner wrote: > Is this homework? > It sure looks like it. > I think we've been getting a LOT of that lately, school must have begun! > > I SUPPOSE that school should be teaching how best to use reso

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
Or directly by rounding in the formula itself =ROUND(INDEX(B3:B21,MATCH(LARGE(FREQUENCY(ROUND(B3:B21,2),ROUND(B3:B21,2)),2 ),FREQUENCY(ROUND(B3:B21,2),ROUND(B3:B21,2)),0)),2) Change the RED colored 2 to 3 for third most repeated number and so on And if you only need to get the second largest num

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

2012-08-17 Thread dguillett1
Looks like homework to me also but this should do it AFTER rounding your column B into column A =INDEX($A$3:$A$21,MATCH(LARGE(FREQUENCY($A$3:$A$21,$A$3:$A$21),ROW(A1)),FREQUENCY($A$3:$A$21,$A$3:$A$21),0)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Amit G

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

2012-08-17 Thread Paul Schreiner
Is this homework? It sure looks like it. I think we've been getting a LOT of that lately, school must have begun! I SUPPOSE that school should be teaching how best to use resources at your disposal to accomplish a task, and this forum is DEFINITELY a valuable resource, so... First of all, you've

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