Thread: Urgent
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SBárbara SBárbara is offline
external usenet poster
 
Posts: 7
Default Urgent

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")