Well said Paul,
But I think Objective of group discussion on any tool (Excel here) is not just helping peoples to complete their project it's also to make them expert so that they can use Excel more smartly . so the challenges gives them opportunity to improve their skills and to understand how Array and other formulas works. Yes, I said that " I don't think helper column is required". but nobody said that it's not possible without helper column. The Objective behind is to make them think deeply about the situation and post accordingly. That's why I said "I was expecting many replies from you." Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 11 August 2012 12:56 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ FW: Excel Formula challenge [Solved] A couple of observations: #1) "I was expecting many replies from you" Many of us don't consider this a "game" We're trying to help others with problems with their projects. So, if it's simply a problem posed as a "challenge", I for one ignore it. #2) You specifically said: "I don't think helper column is required " The result utilizes a "helper column" (E) and therefore doesn't meet the criteria. Paul ----------------------------------------- "Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can." - John Wesley ----------------------------------------- _____ From: Rajan_Verma <rajanverma1...@gmail.com> To: excel-macros@googlegroups.com Sent: Fri, August 10, 2012 2:43:23 PM Subject: $$Excel-Macros$$ FW: Excel Formula challenge [Solved] Hi Guys, I was expecting many replies from you. Well you can see the attached sheet. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 09 August 2012 8:22 To: excel-macros@googlegroups.com Subject: FW: Excel Formula challenge Any Reply??? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 08 August 2012 9:33 To: excel-macros@googlegroups.com Subject: Excel Formula challenge Hi group, Hope you will post an excellent solution here : Let suppose you have a string like below : A|A|A|B|B|C|A|B|C|D As you can see the characters are being repeat in this string output should be : A|B|C|D I don't think helper column is required J You can comment here also http://excelpoweruser.wordpress.com/2012/08/08/excel-formula-challenge/ Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
