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
=MAX(IF(A1:A8=D1,ROW(A1:A8),))
with CSE
On Thu, Jan 10, 2013 at 4:41 PM, Hilary Lomotey resp...@gmail.com 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
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
*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
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
Hi Hilary,
See attached sheet, Hope it will help to you..
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
On Thu, Jan 10,
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.ans...@gmail.comwrote:
Hi Hilary,
See attached sheet, Hope it will help to you..
--
With Regards,
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 resp...@gmail.com 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
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 viper@gmail.com wrote:
[image: Boxbe] https://www.boxbe.com/overview This message
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
10 matches
Mail list logo