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

2015-09-24 Thread Paul Schreiner
- From: Suman <ksuman1...@gmail.com> To: "excel-macros@googlegroups.com" <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

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

2015-09-24 Thread Suman
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 <ksuman1...@gmail.com> > *To:*

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

2015-09-18 Thread Suman
*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 Wes

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

2015-09-16 Thread Suman
ans 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:* Prabhu Pinky <prabhupin...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday,

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

2015-09-16 Thread Suman
t; >>> >>> >>> >>> >>> >>> >>> *“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

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

2015-09-16 Thread Paul Schreiner
...@gmail.com> To: "excel-macros@googlegroups.com" <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 a

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

2015-09-16 Thread Abhishek Jain
--- >> >> >> >> >> >> >> >> *“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
ALSE) > and copy down. > > if you need a more elaborate or macro solution, let us know. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the pl

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

2015-09-15 Thread Suman
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 2 C D 2 D D 2 D D 2 D D Regards, Suman -- Are you =EXP(E:RT)

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

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

2015-09-15 Thread Paul Schreiner
excel-macros@googlegroups.com 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" <ksuman1...@gmail.com> wrote: Dear All,If we have list of company id & Name in excel cell