hi Sam, when i type D1 cell customer name below data coming very perfect but if type D1 cell fist i donot know the Customer name when i D1 Cell Activate then list of Customer name populate after that if type first letter like " L " then in my Customer list start with L will shown like that it ready reference with Tally List Box sheet pl....
Regards chandru On Tue, Feb 21, 2012 at 11:31 PM, Sam Mathai Chacko <samde...@gmail.com>wrote: > Use this in Cell A5 and drag down and across > > > =IFERROR(INDEX(Data!A$3:A$82,SMALL(IF(LEFT(Data!$E$3:$E$82,LEN(MyOutput!$D$1))=MyOutput!$D$1,ROW(INDIRECT(("1:"&ROWS(Data!$E$3:$E$82)))),""),ROW()-ROW(MyOutput!A$4))),"") > > Regards, > > Sam Mathai Chacko > > > On Tue, Feb 21, 2012 at 8:17 PM, chandra sekaran > <duraichan...@gmail.com>wrote: > >> hi exell famly >> >> can any one give my logic code if possible, please........... >> >> chandru >> >> On Mon, Feb 20, 2012 at 10:18 PM, chandra sekaran < >> duraichan...@gmail.com> wrote: >> >>> Dear Maries , >>> >>> First of i would thanks for valuable effort , but what i expected like >>> this only if Activate D1 Cell then Immdiataly like below Unique Customer >>> will shown below on the D1 Cell , than i Enter L letter than Start >>> with L only Bold & selected like that . >>> >>> >>> *Cutomer Name* Lotus ABC COMPAY Adako Tarim Forward >>> International HAND ASSO *LOTUS 123 PVT* ** *LOTUS PVT* ** MURUGA >>> COPANY LTD Reckitt Benckiser SCJ Argentina VAPCO XYZ LTD >>> >>> >>> >>> Thanks for your help >>> >>> Regards >>> chandru >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> On Mon, Feb 20, 2012 at 8:28 PM, Maries <talk2mar...@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> I got your logic. Check the attachment. >>>> >>>> Type your text in cell D1 & Enter. It will give answer. >>>> >>>> Regards, >>>> >>>> MARIES. >>>> >>>> >>>> On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran < >>>> duraichan...@gmail.com> wrote: >>>> >>>>> Hi maries, >>>>> >>>>> thanks for your Reply, >>>>> >>>>> MyOutput Sheet D1 Activate then My List of Cutomer may >>>>> shwon seperate list box or Below D1 Cell there itself we want to >>>>> select >>>>> or like sheet Name Tally List box like that if possible [ First time >>>>> i >>>>> do not know what are the customer are there in my Data so once D1 is >>>>> Activate Unique My Cutomer will display if possible please .... >>>>> >>>>> Regards >>>>> chandru >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Mon, Feb 20, 2012 at 5:54 PM, Maries <talk2mar...@gmail.com> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> Find the attached file. If you type first name in search cell, >>>>>> respective datas will show below. >>>>>> >>>>>> Regards, >>>>>> >>>>>> MARIES. >>>>>> >>>>>> >>>>>> On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran < >>>>>> duraichan...@gmail.com> wrote: >>>>>> >>>>>>> Dear all >>>>>>> Here with attached List Box like Tally is this possible with >>>>>>> excel once Active List box or Cell shown under all name after >>>>>>> enter first letter than showing start with all names like that >>>>>>> Advance Thanks for all >>>>>>> >>>>>>> Regards >>>>>>> chandru >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> FORUM RULES (986+ 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 (986+ 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 (986+ 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 (986+ 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 (986+ 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 >> > > > > -- > Sam Mathai Chacko > > -- > FORUM RULES (986+ 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 (986+ 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