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

On Nov 17, 10:20*pm, Totti wrote:
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?


After 3 hours of thinking, I tried to use something like the solution
you gave but with no results. Your solution seems to work, it has some
results. Nice thought!