View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Totti Totti is offline
external usenet poster
 
Posts: 51
Default find 2nd occurence

Found:
=INDEX(OFFSET($J$3:$J$15,MATCH(1,((A2$K$3:$K$15)* (A2<$L$3:$L$15)),0),
0),MA*TCH(1,((A2OFFSET($K$3:$K$15,MATCH(1,((A2$K $3:$K$15)*(A2<$L$3:$L
$15)),0),0*))*(A2<OFFSET($L$3:$L$15,MATCH(1,((A2$ K$3:$K$15)*(A2<$L
$3:$L$15)),0),0))),*0))

Ste, what do you think?