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 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 >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> > > -- ---------------------------------------------------------------------------------- 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
GG - Updated - Concatenate All Values_Manoj.xlsm
Description: Binary data