Re: $$Excel-Macros$$ Finding the relative position of an item in a list *

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

Re: $$Excel-Macros$$ Finding the relative position of an item in a list *

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 wrote: > [image: Boxbe] This message is eligible > fo

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

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

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

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 wrote: > Hi Hilary, > > See attached sheet, Hope it will help to you.. > > > -- > With Regards, > Noorain Ansari

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

Hi Hilary, See attached sheet, Hope it will help to you.. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On Thu, J

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

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

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

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

Re: $$Excel-Macros$$ Finding the relative position of an item in a list *

Thanks Viper This is not what i require, i will try and explain again sorry if i didnt explain properly, your formula only produces the max ordinal position, assuming Moda is in the first , fifth and tenth row, and in the data validation drop down i select say Moda in the first row, i expect the

Re: $$Excel-Macros$$ Finding the relative position of an item in a list

=MAX(IF(A1:A8=D1,ROW(A1:A8),"")) with CSE On Thu, Jan 10, 2013 at 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