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

2013-01-10 Thread Hilary Lomotey
Very Graeful Prince 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 i

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

2013-01-10 Thread Prince
Hi Hilary, I hope this will may help you =MAX(SUM((A1:A8=D1)*1)) with CSE (: Regards Prince On Thursday, January 10, 2013 4:41:12 PM UTC+5:30, 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 relativ