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
