Hey Thanks Manoj... Now its working.... and serve my purpose.. :) Regds, Manish Pansari +91 9810 88 8281
On Jan 19, 3:02 pm, Manoj kumar <manoj.vishwakarma...@gmail.com> wrote: > ok ...just checked the function, the reason why it is taking much time to > process the values because the column range is too large(here > "*Sheet2!A1:B*"), > just give the limited range like *"Sheet2!$A$1:$B$300"*... it will calculate > much faster... > > I've attached the updated functions for ur reference... > > Regards, > Manoj Kumar > > On Wed, Jan 19, 2011 at 2:56 PM, Manoj kumar <manoj.vishwakarma...@gmail.com > > > > > wrote: > > Hi Manish, > > > Attached is the file with another function and it is much faster than the > > first one... > > > Best of Luck... > > > Regards, > > Manoj Kumar > > > On Wed, Jan 19, 2011 at 2:16 PM, Dave Bonallack <davebonall...@hotmail.com > > > wrote: > > >> Hi Manish, > >> Please attach the solution you have. Perhaps one of us may be able to > >> speed it up. > >> Regards - Dave > > >> > Date: Tue, 18 Jan 2011 23:24:56 -0800 > >> > Subject: Re: $$Excel-Macros$$ Re: Concatenate Value Problem > >> > From: pansari.man...@gmail.com > >> > To: excel-macros@googlegroups.com > > >> > Any Help Pls.. > > >> > - > >> > Manish > > >> > On Jan 18, 5:42 pm, Manish <pansari.man...@gmail.com> wrote: > >> > > Thanks Manoj. > > >> > > It’s really what I was looking for. But it is taking too much time to > >> > > process the result. > >> > > Is it possible to make it faster ?? > > >> > > My excel getting stuck/Not Responding, while I change/add the data or > >> > > copy the formula in another cell. > > >> > > Pls suggest. Thanks in advance. > > >> > > Regds, > >> > > Manish Pansari > > >> > > On Jan 17, 12:28 pm, Manoj kumar <manoj.vishwakarma...@gmail.com> > >> > > wrote: > > >> > > > Hey Manish, > > >> > > > Hope this might help you.... > > >> > > > Cheers, > >> > > > Manoj Kumar > > >> > > > On Mon, Jan 17, 2011 at 10:43 AM, Manish <pansari.man...@gmail.com> > >> wrote: > >> > > > > is it possible or not??? :( > >> > > > > any help pls..... > > >> > > > > - > >> > > > > Manish Pansari > > >> > > > > On Jan 14, 11:21 am, Manish <pansari.man...@gmail.com> wrote: > >> > > > > > Dear Group Friends, > > >> > > > > > I have two work sheet. Sheet1 contain bill number in column B, > >> and > >> > > > > > sheet2 contain bill number and PRA No in column A and column B. > > >> > > > > > My problem is, I want to concatenate the PRA No. with "," for > >> every > >> > > > > > unique bill Number. > > >> > > > > > e.g. Sheet1 date are as Under: > > >> > > > > > Bill No. > >> > > > > > FDN/01 > >> > > > > > FDN/02 > >> > > > > > FDN/03 > >> > > > > > FDN/04 > > >> > > > > > Sheet2 data: > > >> > > > > > Bill No. PRA No. > >> > > > > > FDN/01 M-01 > >> > > > > > FDN/03 M-02 > >> > > > > > FDN/02 M-03 > >> > > > > > FDN/04 M-04 > >> > > > > > FDN/01 M-05 > >> > > > > > FDN/02 M-06 > >> > > > > > FDN/01 M-07 > >> > > > > > FDN/04 M-08 > >> > > > > > FDN/02 M-09 > >> > > > > > FDN/03 M-10 > > >> > > > > > Result required in Sheet1 > > >> > > > > > Bill No. PRA Nos. > >> > > > > > FDN/01 M-01, M-05, M-07 > >> > > > > > FDN/02 M-03, M-06, M-09 > >> > > > > > FDN/03 M-02, M-10 > >> > > > > > FDN/04 M-04, M-08 > > >> > > > > > I know the concatenate formula. but for that i have to apply it > >> > > > > > manually. > > >> > > > > > Please assist me, how can i make it automatic. When I entered > >> new PRA > >> > > > > > No. in sheet2, Sheet1 PRA Nos. get automatically update. > > >> > > > > > Thanks for your regular help and suggestion. > > >> > > > > > Regds,ManishPansari > > >> > > > > -- > > >> ---------------------------------------------------------------------------------- > >> > > > > Some important links for excel users: > >> > > > > 1. Follow us on TWITTER for tips tricks and links : > >> > > > >http://twitter.com/exceldailytip > >> > > > > 2. Join our LinkedIN group @ > >>http://www.linkedin.com/groups?gid=1871310 > >> > > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >> > > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> > > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >> > > > > To post to this group, send email to > >> excel-macros@googlegroups.com > > >> > > > > <><><><><><><><><><><><><><><><><><><><><><> > >> > > > > Like our page on facebook , Just follow below link > >> > > > >http://www.facebook.com/discussexcel > > >> > > > GG - Concatenate All Values_Manoj.xlsm > >> > > > 18KViewDownload- Hide quoted text - > > >> > > > - Show quoted text -- Hide quoted text - > > >> > > - Show quoted text - > > >> > -- > > >> ---------------------------------------------------------------------------------- > >> > Some important links for excel users: > >> > 1. Follow us on TWITTER for tips tricks and links : > >>http://twitter.com/exceldailytip > >> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > >> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >> > To post to this group, send email to excel-macros@googlegroups.com > > >> > <><><><><><><><><><><><><><><><><><><><><><> > >> > Like our page on facebook , Just follow below link > >> >http://www.facebook.com/discussexcel > > >> -- > > >> ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >>http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >> To post to this group, send email to excel-macros@googlegroups.com > > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >>http://www.facebook.com/discussexcel > > > > GG - Updated - Concatenate All Values_Manoj.xlsm > 22KViewDownload- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
