Do you want the *relative* position or the absolute position?

For the first *relative* position:

=MATCH(3,A2:A7,0)

For the second *relative* position assuming the values are sorted and
grouped together as in your sample:

=IF(COUNTIF(A2:A7,3)1,MATCH(3,A2:A7,0)+1,"")

--
Biff
Microsoft Excel MVP


"SBárbara" wrote in message
...
Hi,

How can i get the exact position of a value which is the second time in a
list. For example:

Column A {1,2,2,3,3,3}
I want a formula to obtains the following result:
Column B
4 (line of the matrix for the first "3")
5 (line of the matrix for the second "3")