Return an index number in the range

[Mike7]

Hi.
I have different numbers in the range A1:T1 "12 4 43 23 18 19 37 32 21 7 40 25 41 22 9 11 33 15 29 46" I need a formula for W1 to find an index number of the first occurrence of the value <10 from right to left in the range A1:T1. In this case the value in W1 must be 6.
Also I need a similar formula for the first occurrence of the value between two numbers. In case <40 >30 the value in W1 must be 4.

Thanks.

 

[markmzz]

Now it works in every cell, thanks.

Thanks for the feedback.

Markmzz

 

[T. Valko]

{=COLUMN($U:$U)-MAX(($A$1:$T$1<10)*COLUMN($A:$T))}

Why even use COLUMN($U:$U) ?

Why not simply:

=21-.........