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 > -- ---------------------------------------------------------------------------------- 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
