Hi Rajan, what i mentioned in Final Destination column was required result, What I need is i have to extract those codes from Column A, logic I had mentioned in my first post.
On Sat, Dec 31, 2011 at 10:33 AM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > My Function is working on those Destinations which are listed in > FinalDestination Column , if the Keyword is not found in the list > FinalDestination.. Result will be blank.. **** > > ** ** > > Rajan.**** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Excel_Lover > *Sent:* Dec/Sat/2011 01:00 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ To Extract a text with Conditions**** > > ** ** > > Hi All, > > > I am sorry, I didn't access my mail yesterday, > > Thanks to all of you for your replies, > > @Rajan, > > I have checked your comparison, don,yours, Kris & also Haseeb's, Hasseb's > & Kris's giving same result, but as per your solution in some cells it > results blank cells, I dont know whether I am doing anything wrong or not? > if ignore this error yours and Don's will get same result. > > In all these four solutions Kris's and Haseeb's provide more accurate > result. > > Still there is one thing should be modified on this, as in case of (Cell > ref:A109) > **** > > DMS-BAH-DAM-BAH-DMM**** > > > result should be 'DAM' > > Hope you could do some modifications > > Once again thanks all of you guys for such a great helps. > > > > > > > **** > > On Sat, Dec 31, 2011 at 5:44 AM, NOORAIN ANSARI <noorain.ans...@gmail.com> > wrote:**** > > Excellent Haseeb**** > > ** ** > > On Fri, Dec 30, 2011 at 9:22 AM, Haseeb Avarakkan < > haseeb.avarak...@gmail.com> wrote:**** > > Try this *Array Formula*, > > > =INDEX(MID(A6,ROW(A$1:A$50)*4-3,3),MAX(IFERROR(MATCH(MID(A6,ROW(A$1:A$50)*4-3,3),IF(MID(A6,ROW(A$1:A$50)*4-3,3)="","A",MID(A6,ROW(A$1:A$50)*4-3,3)),0),""))) > > Copy down.. > > ___________ > HTH, Haseeb**** > > ** ** > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > > > **** > > -- **** > > Thanks & regards,**** > > Noorain Ansari**** > > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > **** > > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > **** > > ** ** > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > ** ** > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
