View Single Post
  #5   Report Post  
redeucer
 
Posts: n/a
Default

One more and I've got it.

I had no problem modifying it to find the first value greater than 80. Now
I I need to do between 20 and 80. Here is the formula I tried but it didn't
like it.

=INDEX(K39:K56,MATCH(TRUE,AND(K39:K56<80,K39:K562 0),0))

What do I need to do to make this work?

Thanks again!