Hi Hilary, What i think is instead of just validation list box you should pick combobox of form control and then link its itm index with a cell that give you ur expected output. so please follow the below mentioned steps.
Goto developer tab->Insert->Select Combobox Control->Draw it on ur sheet->right click on the combobox->select format control->select control tab->Choose the range of ur data->in cell link sect any of the cell on ur sheet. and click ok thats all. Done (: enjoy regards Prince On Thursday, January 10, 2013 6:07:33 PM UTC+5:30, hilary lomotey wrote: > > Thanks Viper i thinks its a good idea, i can do some modification and see > what happens but its a great step for me, thanks to every one who assisted. > thanks so much > > On Thu, Jan 10, 2013 at 12:30 PM, The Viper <vipe...@gmail.com<javascript:> > > wrote: > >> [image: Boxbe] <https://www.boxbe.com/overview> This message is >> eligible for Automatic Cleanup! (vipe...@gmail.com <javascript:>) Add >> cleanup >> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D0bFb%252BUbwXMhXZy7QYsJCyXh1YpeBlWLGCCrDfadl3X7%252FNV3foXfN2xc4Wr%252F61hOXvfLY0hXdI8jsrh0Kw5lwqoy85VsalpHI%252B3MMQvdXIncuQhQBhdpBZ1ierYI4sr%252FZeSZIX1teOJY%253D%26key%3DcU9IFfeKxuJFfjwiutoeP1pERg9Y%252FMXwyqbwIY8HM54%253D&tc=13317400054_213030034>| >> More >> info<http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13317400054_213030034> >> >> >> What you're asking is not possible without helper column. >> here is my openior. PFA >> >> On Thu, Jan 10, 2013 at 5:39 PM, Hilary Lomotey >> <res...@gmail.com<javascript:> >> > wrote: >> >>> Thanks Noorain, >>> >>> for what am trying to do, i need a formula instead. But that is the >>> exact principle of what i was explaining. thanks >>> >>> >>> On Thu, Jan 10, 2013 at 12:03 PM, NOORAIN ANSARI >>> <noorain...@gmail.com<javascript:> >>> > wrote: >>> >>>> Hi Hilary, >>>> >>>> See attached sheet, Hope it will help to you.. >>>> >>>> >>>> -- >>>> With Regards, >>>> Noorain Ansari >>>> http:// >>>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> >>>> http:// >>>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> >>>> >>>> >>>> On Thu, Jan 10, 2013 at 5:28 PM, Hilary Lomotey >>>> <res...@gmail.com<javascript:> >>>> > wrote: >>>> >>>>> Very Grateful Exl. learner >>>>> >>>>> But i guess i didnt explain myself properly, i will try and again >>>>> >>>>> Assuming Moda appears in the First, Fifth and tenth Row, if i select >>>>> Moda from the the data validation drop down ie the first moda, i expect >>>>> to >>>>> see 1, if i select Moda from the fifth row, i expect to see 5 and if i >>>>> select moda from the tenth row, i expect to see 10 and so on. Pls hope >>>>> this >>>>> clarifies my requirement. thnks >>>>> >>>>> On Thu, Jan 10, 2013 at 11:50 AM, Ms-Exl-Learner >>>>> <ms.exl....@gmail.com<javascript:> >>>>> > wrote: >>>>> >>>>>> *In F1 cell *- *Non Array formula * >>>>>> >>>>>> *=LOOKUP(2,1/(A1:A8=D1),ROW(A1:A8))* >>>>>> >>>>>> OR >>>>>> >>>>>> *=SUMPRODUCT((MAX((A1:A8=D1)*ROW(A1:A8))))* >>>>>> >>>>>> >>>>>> On 10-01-2013 4:41 PM, Hilary Lomotey wrote: >>>>>> >>>>>> Hi Experts, >>>>>> >>>>>> In the attached, i have a list of items, some are repetitive in the >>>>>> list, if i want to find the relative position of each item what formula >>>>>> can >>>>>> be helpful, the normal match will for instance if an item appears twice >>>>>> in >>>>>> different positions will only give me the position of the first item, >>>>>> but >>>>>> i want a formula, that will give me the position of the second item if i >>>>>> select it >>>>>> -- >>>>>> Join official Facebook page of this forum @ >>>>>> https://www.facebook.com/discussexcel >>>>>> >>>>>> FORUM RULES >>>>>> >>>>>> 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) Jobs posting is not allowed. >>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>> >>>>>> NOTE : Don't ever post 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-...@googlegroups.com<javascript:> >>>>>> . >>>>>> To unsubscribe from this group, send email to >>>>>> excel-macros...@googlegroups.com <javascript:>. >>>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en >>>>>> . >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Join official Facebook page of this forum @ >>>>>> https://www.facebook.com/discussexcel >>>>>> >>>>>> FORUM RULES >>>>>> >>>>>> 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) Jobs posting is not allowed. >>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>> >>>>>> NOTE : Don't ever post 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-...@googlegroups.com<javascript:> >>>>>> . >>>>>> To unsubscribe from this group, send email to >>>>>> excel-macros...@googlegroups.com <javascript:>. >>>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en >>>>>> . >>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>>> Join official Facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES >>>>> >>>>> 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) Jobs posting is not allowed. >>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>> >>>>> NOTE : Don't ever post 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-...@googlegroups.com<javascript:> >>>>> . >>>>> To unsubscribe from this group, send email to >>>>> excel-macros...@googlegroups.com <javascript:>. >>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> >>>> -- >>>> Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 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) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post 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-...@googlegroups.com<javascript:> >>>> . >>>> To unsubscribe from this group, send email to >>>> excel-macros...@googlegroups.com <javascript:>. >>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>>> >>>> >>>> >>> >>> -- >>> Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post 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-...@googlegroups.com<javascript:> >>> . >>> To unsubscribe from this group, send email to >>> excel-macros...@googlegroups.com <javascript:>. >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>> >>> >>> >> >> -- >> Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 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) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post 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-...@googlegroups.com<javascript:> >> . >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> >> > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.