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.
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=470999