BenjieLop wrote:
> zangief Wrote:
>
>>I need to return the position of a cell in a list. For example, I have
>>the list:
>>
>>A
>>B
>>C
>>D
>>E
>>F
>>
>>I need a funciton that will tell me if D is the first cell, second,
>>third, etc...
>>
>>Thanks.
>
>
> ASSUMING your entries are in Column A (A1:A6), try this formula
>
>
> =\"A\"&SUMPRODUCT(($A$1:$A$6=\"D\")*(ROW($A$1:$A$6)))
>
> and see if this is what you need.
>

What happens if you have more than one D in the target range?