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!
|