Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-24 Thread Paul Schreiner
esley - From: Suman To: "excel-macros@googlegroups.com" Sent: Thursday, September 24, 2015 2:10 AM Subject: Re: $$Excel-Macros$$ Company name based on maximum occurrence Dear Paul,Thanks you so much its working fine!! I'm still learner and starting of the

Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-23 Thread Suman
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:* Suman > *To:* "excel-macros@g

Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-17 Thread Suman
eeds. > > *Paul* > - > > > > > > > > *“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* &

Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-16 Thread Suman
the first entry. >>> >>> If you're using Excel2007 or greater, you can use =Countifs() >>> (which is countif with multiple criteria) >>> >>> in D2, put: >>> =COUNTIFS(A:A,A2,B:B,B2) >>> and copy down. >>> >>>

Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-16 Thread Abhishek Jain
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:* Suman &g

Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-16 Thread Suman
n 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:* Suman > *To:* "excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-16 Thread Paul Schreiner
Suman To: "excel-macros@googlegroups.com" Sent: Wednesday, September 16, 2015 5:15 AM Subject: Re: $$Excel-Macros$$ Company name based on maximum occurrence Thank you so much Mr. Paul its working!! This requirement is for Weekly basis and need to work on approximate 1 lack data. Can you p

Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-16 Thread Suman
an,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > -------------- > *From:* Prabhu Pinky > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, September 15, 2015 8:24 AM > *Subject:* Re: $$Exc

Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-15 Thread Paul Schreiner
Sent: Tuesday, September 15, 2015 8:24 AM Subject: Re: $$Excel-Macros$$ Company name based on maximum occurrence Use vlookup. On 15-Sep-2015 5:31 PM, "Suman" wrote: Dear All,If we have list of company id & Name in excel cell then how can I find maximum occurrence of compan

Re: $$Excel-Macros$$ Company name based on maximum occurrence

2015-09-15 Thread Prabhu Pinky
Use vlookup. On 15-Sep-2015 5:31 PM, "Suman" wrote: > Dear All, > If we have list of company id & Name in excel cell then how can I find > maximum occurrence of company name against that company ID. > > Example: > Co ID Name Required Output 1 A A 1 A A 1 A A 1 A A 1 A A 1 A A 1 B A 1 B A > 1 B A