Hi dave, VBA also ok for me.
Regards Girish On Wed, Nov 3, 2010 at 4:07 PM, Dave Bonallack <davebonall...@hotmail.com>wrote: > Hi Girish, > Can we use VBA? > Regards - Dave. > > ------------------------------ > Date: Wed, 3 Nov 2010 12:36:23 +0530 > > Subject: Re: $$Excel-Macros$$ help required > From: girishkumar832...@gmail.com > To: excel-macros@googlegroups.com; davebonall...@hotmail.com > > Hi Dave, > > Pls. find attached file. i have added formulas in respective columns. > > Left formula i started with =left(A2,13) then 12, 11, 10......... ending > =left(A2,3) > > i dont want to use left & vlookup function for getting data, i want direct > formula for getting data. > > i dont mind for answer questions feel free to ask. > > thanks in advance > > Girish > > On Wed, Nov 3, 2010 at 7:59 AM, Dave Bonallack > <davebonall...@hotmail.com>wrote: > > Hi Girish, > > *in "USED VLOOKUP HERE" column i used Vlookup function taken table _array > as "SYSTEM DATA"* > This is not a formula. I need the actual formula you used so I can see what > you are trying to achieve. > I don't mind persisting with this, but you will need to keep answering my > questions. I don't like guessing. > Regards - Dave. > > > > ------------------------------ > Date: Tue, 2 Nov 2010 19:28:15 +0530 > > Subject: Re: $$Excel-Macros$$ help required > From: girishkumar832...@gmail.com > To: excel-macros@googlegroups.com; davebonall...@hotmail.com > > > Hi Dave > > thanks for your reply > > actually i removed formula because file size is big > > in "USED HERE LEFT FUNCTION" i used left function like =left(A2,13) and > pasted it till end and in "USED VLOOKUP HERE" column i used Vlookup function > taken table _array as "SYSTEM DATA" AND pasted till and after the in filter > i seleted #n/a and again i edited the left function Like =left(A2,12) and > then again vlookup > > Like wise decreasing Left Num_chars and vlookup i got all realtive data in > "USED VLOOKUP HERE" column > > but this very lengthy process and taking too much time for calculating > vlookup and data also very huge > > so i need any easy logical function having same answer as in Column "USED > VLOOKUP HERE" > > hope u understand > > Thanks in advance > > Girish > > > On Tue, Nov 2, 2010 at 10:08 AM, Dave Bonallack <davebonall...@hotmail.com > > wrote: > > Hi, > Your sample sheet gives insufficient and contradictory info. > Column B has a header which says "USED HERE LEFT FUNCTION" but there is no > left function used there - the data is just entered as text, and the length > of text varies, which means that the left function probably wasn't used. > Column C has a header which says "USED VLOOKUP HERE" but again the data is > just text. > Column D has a header which says "Your Logical Function Pls" but you give > no indication as to what you want the logical function to do. > We would love to help you, but it's just not possible with this info. > Regards - Dave. > > > > ------------------------------ > Date: Mon, 1 Nov 2010 19:37:37 +0530 > Subject: Fwd: $$Excel-Macros$$ help required > From: girishkumar832...@gmail.com > > To: excel-macros@googlegroups.com > > Dear Experts, > > Any updates!!! > > ---------- Forwarded message ---------- > From: *girish kumar* <girishkumar832...@gmail.com> > Date: Thu, Oct 21, 2010 at 2:52 PM > Subject: Re: $$Excel-Macros$$ help required > To: excel-macros@googlegroups.com > > > Hi > > Can anyone help me on this > > > On Tue, Oct 19, 2010 at 3:06 PM, girish kumar <girishkumar832...@gmail.com > > wrote: > > hi experts, > > its a rolling up method > > for example > > if raw cdr having No 93854512115 > then formula should find name for this no if didnt then > it roll up one no and then find again (like 9385451211) > till finding name it will rolling up > > hope now u understand > > Girish > > > > On Tue, Oct 19, 2010 at 1:24 PM, Jai <jaihumtu...@gmail.com> wrote: > > Please check the attachment, > > > > > > > > > > > > > > > On Tue, Oct 19, 2010 at 10:32 AM, girish kumar < > girishkumar832...@gmail.com> wrote: > > Hi Krishna, > > see file attached, in that second sheet u see in b column i used Left > function and in c column Vlookup > > left function i used =left(A2.13) > > and vlookup answer is #N/A > > Because In System Data sheet Left function answer is not there > > if i decrease the no's in left function i ll get the answer > > likewise till i get answer i have to decrease the no in left function > > hope u understand now > > data will be very huge and it take long time to vlookup calculate > > so try to give any logical function. > > Thanks in advance > > Girish > > On Mon, Oct 18, 2010 at 9:18 PM, krishna mummina > <lovemekris...@gmail.com>wrote: > > Dear Girish, > > Sorry I didn't understand what you are looking for, > > Please give an Example, what you want exactly? > > May be i have some communication problem to understand your query. > > Thanks, > Excelkid > > On Mon, Oct 18, 2010 at 7:52 PM, girish kumar < > girishkumar832...@gmail.com> wrote: > > Dear Experts, > > need one urgent help from you guys i have attached one file having 2 sheets > named "system data" & "Raw CDR" > > i need a formula for getting name in sheet Raw CDR > > for exam > > sheet system data having no > > 93 Afghanistan Other > > and Raw Cdr having No > > 93854512115 > for getting destination name in sheet raw CDR i m using 1st left function > > like =left(A2,13) and again giving vllokup formula as mentioned in sheet if > data not found, then i decrease the no's in left function as 12, 11, 10 till > i get the destintaion name > > problem is data will be very huge and take more time to calculate > > so friends if u can find any logical function for this it'll help me very > much > > thanks in advance > > Girish > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > > > > -- > Thanks For Mail. > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > > > > > > -- > Warm Regards, > > *Girish Sherigar* > > *(¨`·.·´¨) * > *`·.¸(¨`·.·´¨)* *Keep* > *(¨`·.·´¨)¸.·´ Smiling!* > *`·.¸.·´* > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > > > > -- > Warm Regards, > > *Girish Sherigar* > > *(¨`·.·´¨) * > *`·.¸(¨`·.·´¨)* *Keep* > *(¨`·.·´¨)¸.·´ Smiling!* > *`·.¸.·´* > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > > > > -- > Warm Regards, > > *Girish Sherigar* > > *(¨`·.·´¨) * > *`·.¸(¨`·.·´¨)* *Keep* > *(¨`·.·´¨)¸.·´ Smiling!* > *`·.¸.·´* > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Warm Regards, *Girish Sherigar* * (¨`·.·´¨) * *`·.¸(¨`·.·´¨)* *Keep* * (¨`·.·´¨)¸.·´ Smiling!* * `·.¸.·´* -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
